How do you run macros that is on the Personal.xls with Labview

[japflare]

I have Labview 7.0 and Excel 2002. I have Labview openning up an Excel file. I also have a Macro stored in my personal workbook that runs on that file whenever it is openned, but when labview opens the file it does not run the macro. I have made it also so that it opens personal.xls before openning the file, but this changes nothing. Does anyone know a way to make the global macro that I have saved to my personal workbook run when I open an excel file from Labview?

[Michael_Munroe]

Stored macros are not automatically executed during ActiveX automation. To do so would almost always cause problems. You can however use ActiveX to run any macro in any open workbook.

To run the Auto_Open macro in your Personal.xls use this method:
Excel._Workbook.RunAutoMacros(xlAutoOpen)

or:
Excel._Application.Run("Personal.xls!Auto_Open")

Make sure that the other workbook is the active workbook before you run the macro.

Michael Munroe
Certified LabVIEW Developer
www.abcdef.biz