LabVIEW
ActivX control excel?
Hi Kwai,
There is a known localization issue with LabVIEW 6.0 and Microsoft Excel Object Library. What language version for Windows and Excel are you using? Are you using exactly the same version of Windows and Excel on the two machines? What country and language is chosen under "Control Panel >> Regional and Language Options"?
By making sure that the settings are the same on computer "B" as they are on "A", you should be able to see the Microsoft Excel Object Library under LabVIEW.
If you are unable to have the same versions on computer "B" as on "A", here's a workaround that was reported by a customer that couldn't see the Excel Object Library after upgrading from Excel 97 to Excel 2000:
NOTICE: Editing the Registry is on your own risk! Always back up the registry (Registry >> Export Registry) before making changes to the keys.
When checking in the registry under HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}, a path was found for EXCEL9.OLB. However, it was noticed that folder "1.2" for the Excel 8.0 Object did not have a value (path) set. The other
folders (1.0 and 1.3) both have path information. Folder "1.2" was set with the same path as for folder "1.0" and "1.3". After rebooting, EXCEL9.OLB appeared in the in the list of ActiveX Classes in LabVIEW.
There is a known localization issue with LabVIEW 6.0 and Microsoft Excel Object Library. What language version for Windows and Excel are you using? Are you using exactly the same version of Windows and Excel on the two machines? What country and language is chosen under "Control Panel >> Regional and Language Options"?
By making sure that the settings are the same on computer "B" as they are on "A", you should be able to see the Microsoft Excel Object Library under LabVIEW.
If you are unable to have the same versions on computer "B" as on "A", here's a workaround that was reported by a customer that couldn't see the Excel Object Library after upgrading from Excel 97 to Excel 2000:
NOTICE: Editing the Registry is on your own risk! Always back up the registry (Registry >> Export Registry) before making changes to the keys.
When checking in the registry under HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}, a path was found for EXCEL9.OLB. However, it was noticed that folder "1.2" for the Excel 8.0 Object did not have a value (path) set. The other
folders (1.0 and 1.3) both have path information. Folder "1.2" was set with the same path as for folder "1.0" and "1.3". After rebooting, EXCEL9.OLB appeared in the in the list of ActiveX Classes in LabVIEW.
