where can i get help files on the Mcrosoft word 9.0 object library used in CVI

[JonathanN]

Hi himi,

Refer to the Microsoft document entitled How to find and use Office object model documentation. In your case, you will be looking at the Vbawrd9.chm help file which I believe will be located in the C:\Program Files\Microsoft Office\OFFICE\1033\ directory.

Also refer to the Unable to Load Microsoft Excel/Word Help in LabWindows/CVI KnowledgeBase.

Hope this helps!

Best Regards,

[JoeN]

I am having the same problem with the Excel 9.0 Object Library, but after following the cited recommendations, the "Could not launch help file" message still appears.  Here are my configuration details:

• Windows XP Pro, SP2 
• Labwindows/CVI 8.5
• Excel/Office 2003
• Excel Report and Microsoft Excel 9.0 Object Library loaded from C:\Program Files\National Instruments\CVI85\toolslib\activex\excel

 

Since I'm running Office 2003, the help files for Office 2000 don't exist on my computer, so I followed the recommendations, kind of, by finding an Office 2000 disc and manually copying VBAXL9.CHM and VBAXL9.AW.  I first tried them in the default Office 2003 folder, C:\Program Files\Microsoft Office\OFFICE11\1033.  That didn't work, so I created the Office 2000 default folders, C:\Program Files\Microsoft Office\Office\1033, and put the files there, and they still don't work (same "not found" message).  I tried closing and re-opening Labwindows, un-loading and re-loading the Instrument files and rebooting the computer.  Is there a registry key or environment variable that's needed?

I can open and use the help file, VBAXL9.CHM, in windows, but, either it's still not the right file, or the Excel 9.0 Object Library or Labwindows filters it somehow.  Say, for example, I want to use the Excel_RangeInsert() function.  There is no direct correlation that I can see between that function name and anything in VBAXL9.CHM.  The closest thing I found is "Insert Method".

Thanks for any help

Joe

[tstanley]

I'm having a similar problem.  I'm using Office 2007, CVI 2010, and Windows XP.  I tried following the instructions in the "Unable to Load Microsoft Excel/Word Help in LabWindows/CVI" document, but it just seems to be out of date, like I couldn't find the "Visual Basic Help" option in Add/Remove features list.  Microsoft's own document "How to find and use Office object model documentation" is also out of date, as it doesn't talk about Office 2007 either, but it appears that the .chm files are in place in the Office12\1033 directory, which suggests to me that they are now just installed without asking.  However, CVI just gives the "Could not launch the help file" error in the function panels for the Microsoft Excel 9.0 Object Library.  Any ideas on how to get this to work?

[D_Biel]

Can you open these help files independent of CVI?

[tstanley]

Looks like you may be right.  Most of the files appear to be empty (!)  Two of them are not, VBAOWS10.CHM and VBSCRIPS.CHM.  I can open those ones by double-clicking on them.  Which one(s) is CVI looking for?

[Hassan_Atassi]

Hi tstanley,

Have you tried using the excel report library? This can be found in C:\Program Files\National Instruments\CVI2010\toolslib\activex\excel

[tstanley]

Loading that library doesn't seem to fix the help issue with the Excel2000 library.  On the other hand, the ExcelReport library help works, and after looking through what's available it seems like it will do everything I need, and looks to be easier to use to boot.  So I'm going to switch to the ExcelReport library for what I'm trying to do.  Thanks.

[NoVIsonme]

Unfortunately Excel Report doesn't seem to help me much. I'm trying to use it for report writing which I believe requires access to pivot tables. Sadly I've only had to delve into the arcane depths of M$ because NIReport won't handle charts... Now where's that suggestion thread? 🙂 Seriously, this problem with the Object Library help is badly compromising what could be a very useful tool. Surely it's nothing more than a bug fix type of issue?

[tstanley]

Looks like one thing that is missing in the Excel Reports library is how to connect to an existing (already opened) instance of Excel.  It appears that I can use the Excel2000 functions, like Excel_ActiveApp(...), to connect, then I can use the ExcelReport functions like ExcelRpt_GetApplicationAttribute(...) on the handle I get back.  This should work, right?  (it seems to, at least on the application level).  However, I'm also trying to figure out how to connect to existing workbooks and sheets in Excel, which would have to be done through the Excel2000 library, and once again I'm stumbling in the dack because the documentation not working.  So I'll have to put my request back in for a fix.  Thanks.