Hello all,
Can anyone tell me how I can open a workbook, but without making it the active workbook?
I'm writing this macro code, in which I need to open a log file and log certain events to it. When I open it in a regular fashion (Workbooks.Open), the file automatically becomes the active workbook, therefore displaying on the user's screen. Even if I quickly activate another workbook in the next statement, the user still sees the log workbook show up on the screen - be it briefly.
Here's the code I use:
How can I open this log workbook without it showing up on the screen?
Thanks for looking into this.
Pierre
Can anyone tell me how I can open a workbook, but without making it the active workbook?
I'm writing this macro code, in which I need to open a log file and log certain events to it. When I open it in a regular fashion (Workbooks.Open), the file automatically becomes the active workbook, therefore displaying on the user's screen. Even if I quickly activate another workbook in the next statement, the user still sees the log workbook show up on the screen - be it briefly.
Here's the code I use:
Workbooks.Open Filename:=name of the log file<NAME file log of><NAME file log the of>
Workbooks(name of another workbook<NAME of workbook another><NAME of workbook another>).Activate
I use Excel 2007, but must save whatever I do in Excel 2003, for some users are still stuck with that version.How can I open this log workbook without it showing up on the screen?
Thanks for looking into this.
Pierre