crush
08-22-2007, 12:33 PM
I want to import data from a closed workbook into a currently open workbook.
The problem I have is that the closed workbook, when it opens, it runs macros in the Workbook_Open routine. Is there a way I can bypass the workbook open routines when I call it using VBA from my currently open workbook?
When the closed workbook is opened from excel or from double clicking the file in windows explorer, I want the Workbook_Open routines to run. But when I open the closed workbook, using VBA, from my currently open workbook, I don?t want the Workbook_Open routines to run.
I tried to set a ?public flag? in my currently open workbook, but when the closed workbook opens the public flag is ?empty?.
Basically I am trying to build an ?import? feature where by user data saved in the ?closed workbook? can be imported into a new version of the workbook.
Any help or suggestions would be welcomed
Kindest regards
CRush
The problem I have is that the closed workbook, when it opens, it runs macros in the Workbook_Open routine. Is there a way I can bypass the workbook open routines when I call it using VBA from my currently open workbook?
When the closed workbook is opened from excel or from double clicking the file in windows explorer, I want the Workbook_Open routines to run. But when I open the closed workbook, using VBA, from my currently open workbook, I don?t want the Workbook_Open routines to run.
I tried to set a ?public flag? in my currently open workbook, but when the closed workbook opens the public flag is ?empty?.
Basically I am trying to build an ?import? feature where by user data saved in the ?closed workbook? can be imported into a new version of the workbook.
Any help or suggestions would be welcomed
Kindest regards
CRush