In Excel 2007as active X in Labview, when you right click on a Run method there is no Help for "Run"

[khurshe]

In Vista OS, Use Excel 2007 as active X Object in Labview and when you right click on a Run method in the Labview code and then click on "Help for Run" no microsoft help explaination page for "Run Method" pops up, as it does in Excel 2003 and Windows XP. I am sure someone using excel as active x Object in Labview has found the solution. 

[khurshe]

I have to add this comment : I suspect the reason why explaination page does not open in Vista OS - Excel 2007 is that when you open Excel 2007 and then click on help and in help first you select "developer reference" and then you click on "Table of reference" you will not see the book document " Microsoft Excel visual Basic Reference". Excel 2003 help has this reference. By the way " Microsoft Excel Visual Basic Reference" has the complete list of all the Methods and Properties. Please someone comment!

[khurshe]

I have to rewrite the above message, because I wrongly wrote "Table of reference" instead of "Table of Content". The correct message reads as follows:

I have to add this comment : I suspect the reason why explaination page does not open in Vista OS - Excel 2007 is that when you open Excel 2007 and then click on help and in help first you select "developer reference" and then you click on "Table of content" you will not see on the left side of help page in the "Table of Content", the document book " Microsoft Excel visual Basic Reference". Excel 2003 help has this reference. By the way " Microsoft Excel Visual Basic Reference" has the complete list of all the Methods and Properties. Please someone comment!

[smercurio_fc]

Did you actually install the Visual Basic Help? Normally this is not installed, and you need to do a custom installation of Excel to install this.

[khurshe]

The Excel help file "VBAXL10" is installed in directory c:\program files\microsoft office\office 12\1033. I have also installed (at that time I logged in as Administrator) 2 Updates from microsoft office website : "Updates for microsoft office Excel 2007 help" and "Updates for microsoft office 2007 Help for common features". After the Installation it said, the updates are installed, but in the "1033" directory it did not bring any change, which was supposed to be brought. May be Vista do'nt allow any changes in it's program files, even from administrators. On the microsoft office website there is another update available "The 2007 microsoft office suite service pack 1 (SP1)". I do'nt know, if I install this update is it going to solve my problem? May be it is already installed on my computer. In Excel 2007 Help in "Table of Contents" I can see "Excel Object Model Reference" which has the complete list of excel active X sub-objects. Each sub-object has it's own list of Methods and Properties. When you go out of Labview to excel Help, and in the "search box" if for eg. you write "Run Method", the complete Explaination Page for "run Method" will appear; but the same thing does not happen from Excel Methods and Properties inside the Labview code in your Labview VI. 

[Charlie_P]

Hello khurshe,

I am not quite sure I follow your posts.  How are you adding the Excel class to your .vi?  What exactly are you expecting LabVIEW to display?

[khurshe]

Hi! Charlie

From the Attachment you can open "ExcelMacroExample.vi". It has an Excel Method or Invoke Node called "Run". you should Right Click on "Run". In the Pop-up menu, click on "Help for Run". Now when I do this on a computer having operating System "XP" and "Excel 2003", a Microsoft Help Page opens explaining different ways  to use Excel "Run" Method. But when I do the same on a computer having operating system "Vista Premium" and "Excel 2007", the Help Page for Excel "Run" Method does not open. 

[Charlie_P]

Hello khurshe,

I have Windows XP and Excel 2007 on my computer.  Using your files, when I right-click, "Help for Invoke Node," the LabVIEW help comes up.  When I right-click, "Help for Run," nothing happens.  I changed the method in the Invoke Node from Run to about half a dozen other methods; none of them had Help functionality either.

A Corrective Action Request (our internal process to fix bugs and make other product changes) on this issue has been filed.  Unfortunately, at this point, there seems to be nothing that we can do to make that menu option work for you.  The only workaround that I know of is to use the Excel Help file directly or to search Microsoft's website.  We can look forward to seeing a change in a future release of LabVIEW.

[khurshe]

Thanks! Charlie