trouble running excel macro

[glamb]

I am creating 3 workbooks, then adding data to just one workbook and formatting it. I have written an excel macro that does all this very nicely, but when I try to run it from the VFP 9 code, I get a message that the macro may not be available in this workbook or all macros may be disabled, except that I have set the macro security to enable all macros and I have checked the active workbook and can run the macro if I put set step on and do it manually.

This is the code:
oexcel.application.run("PERSONAL.XLSB.vfp2xls")

 

[JRB-Bldr]

Rather than trying to run an Excel Macro with your Automation, you should use Automation to execute the same string of Excel (VBA) commands as are used within the Macro.

Yes, since the command language of an Excel Macro is VBA and you need to use VFP Automation syntax, there may be some parts that need converting, but they should be few.

Good Luck,
JRB-Bldr

 

[glamb]

I figured it out.
oExcel.APPLICATION.RUN("PERSONAL.XLSB!vfp2xls")
It was just a typo. And it actually is easier to run the macro from the VFP code. But thanks anyway.