I get the error code -2146827284 when trying to run an Ecxel macro from LabVIEW.

[S-Man]

I am trying to insert data in an Excel workbook and then run a macro which I recorded in Excel to produce a plot.
This worked great on a laptop running W2K + LV7 and Office 2000.
I am now trying to do the same thing on a WinXP + LV7 + Excel 2002 and I get this error.
The complete message is:
"Error -2146827284 occurred at Exception occured in Microsoft Excel, Programmatic access to Visual Basic Project is not trusted
. Help Path is C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm and context 0 in Excel Import Module.vi->LV report test1.vi

This error code is undefined. No one has provided a description for this code, or you might have wired a number that is not an
error code to the error code input."

Can anyone shed some light on this. Running a macro is the obvious and easy way to get this work done.
See the attached VI. It includes the macro and some sample data to run it on.

[Joe_Guo]

In Excel, goto Tools -> Macro -> Security, check all the boxes so it trust all macro source (you can test to find out which one works, or check all of them), also try to lower the security setting from highest to medium or even lowest.

-Joe

[Feroz]

Hi,

I have attached a link to a document that discusses the error you are getting:
Error -2146827284 When Importing a Macro to Office 2002/XP

I hope this helps.

Sincerely,

Feroz
National Instruments

[S-Man]

Thank you, I found the problem myself yesterday.
It works like a charm now.