LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot open Excel using Activex

I have office2000 and using activex I can only open word and powerpoint but not excel... Everytime when I try it gives "Error -2147319784 occured at old format or invalid type library." Thank you very much for any help you provide about this problem.
Regards,
0 Kudos
Message 1 of 3
(3,171 Views)
The link below may offer some clues.
http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=506500000008000000852F0000&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0
0 Kudos
Message 2 of 3
(3,171 Views)
Hello,
Please first check that you are using Excel 2000 examples.
This error we have only seen happen in a very few specific cases. Usually this only occurs on a system that has a foreign language OS of some type installed. The fix below may not work in all situations, especially, if you are trying to use Word as your ActiveX component.
Error -2147319784 is caused by LabVIEW failing to recognize the typelibrary for certain ActiveX components. Note: At this time we are only aware of this not working for Microsoft Office Products.

To fix this problem, you must modify your Windows Registry file.
Warning: Deleting or changing the wrong entry in the Windows Registry could render your computer unusable! National Instruments takes no responsibility for errors mad
e by modifying the Windows Registry.
Here is how to modify the Windows Registry:

Launch the Registry Editor. Go to Start > Run and type regedit at the command line. Press OK.

Under HKEY_CLASSES_ROOT locate the TypeLib Folder.

Search for the Excel or Word key. It should be some long combination of letters and numbers such as:

{00020813-0000-0000-C000-000000000046}

There are two base keys named "1.0" and "1.2". Under the "1.0" key, right-click and create a new key. Name it "0" (zero). (See the attached images, Registry_Before.gif and Registry_After.gif.)

Under the new "0" key, create another new key called "win32".

Under the "1.0" > "9" > "win32" key you will find the path to the Excel5 or Word-library on the machine. Copy this path into the key that you created in the previous step.

Exit the Registry Editor, saving your changes.

Launch LabVIEW.

Zvezdana S.
National Instruments
0 Kudos
Message 3 of 3
(3,171 Views)