VB Application calling Excel File with Macro - Macros not working 1

[mimpuerto]

Hi. I have an Excel application. This application is opening multiple Excel files. The Excel file contains macros. The macro opens another Excel file. When triggered by a VB application, the macro is executed except all methods issued. Thus, if i issue OPEN method, the macro will just run the line but not actually opening anything. But if i run in excel, it will execute the command.


Please help me find solution. Thanks a lot!

 

[xlbo]

the workbook OPEN event will NOT fire if the workbook is opened via code

You need to call the macro from the code that opens the workbook

eg

pseudo code

workbboks("C:\A.xls&quot.open
Application.Run("A.XLS!workbook_open" Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde