I am having trouble getting a macro to run in Excel once I have the workbook open. I first tried an Auto_Activate macro. It worked fine if I opened the workbook using Excel. When I used VFP 5.0 and OLE Automation to open the workbook it would not run the macro. So I renamed the macro to "Master" and tried to just run it once the workbook was open.

Here is the code I'm using. The macro actually runs but I get an OLE error code Ox800a9c68, Unknown OLE status code.

oEXCEL = CREATEOBJECT("Excel.Application")
oEXCEL.Workbooks.Open("\MACROS.XLS")
oEXCEL.Application.Run("'\MACROS.XLS'!Master")

Any help would be appreciated.

Thanks,
Mike