MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Opening Workbooks with macros programmatically.

Posted by keefas on August 12, 2001 11:30 PM

If somebody knows how to make the macros work in a workbook openend by a macro in an other workbook (see post "What am I doing wrong with workbook opening" from below for details) please help, I´m going crazy with this.

Posted by Ivan F Moala on August 13, 2001 2:28 AM

What version and service realease of excel are
you using ??
How are you assigning the macro to run the open a button / object or shortcut key?


Posted by keefas on August 13, 2001 3:25 AM

I´m using 97 on NT. The macro that opens the workbook assigns when you dblclick on Image on a userform, and the macro in a just opened workbook starts at workbook_open event. There is a really simple example on what doesn´t work below under my first post "What am I doing wrong with my workbook opening". When you run it line by line with F8, you can see that the macro doesn´t perform any of the workbook editing commands eventhough it reads them. If you open the WB2 manually it works just fine...