activex server excel example in LV 8.0

[battler.]

Does anybody know how to get the following ActiveX Server example working for LV 8?

labview\examples\comm\freqresp.xls 

The menu items appear to have been moved.  The equivalent (VI Server) options under Tools-->Options don't appear to work.

Has anybody managed to get the Ctrl+M and Ctrl+L in the spreadsheet to generate calls to the VI?

Thanks.

[OliviaC]

Hi battler,

Have you enabled macros in Excel? You will need to do this to be able to run the example.

Which version of Excel (i.e. 2007, 2003 or 97) are you using?

[battler.]

Thanks.  Yes I jus had to enable macros in Excel 2007.

I had a look at that VI.  How does the connectivity with Excel exactly work?

[OliviaC]

Hi battler,

The VI itself can run on its own. There is a Visual Basic script that you can look at to see how the Frequency Response VI is called from Excel. Within Excel go to the Developers tab and click on Macros. Then select LoadData and press Edit to look at the script. 

There is some additional information here and here.