Questions about opening a workbook in code

  • Thread starter Thread starter DawnTreader
  • Start date Start date
D

DawnTreader

Hello All

when i open a workbook in code, does it open in the same instance of excel,
or a brand new instance.

i have a workbook which i am using as a "dashboard" and i want it to open
other workbooks, but i would also like those to load seperately in the
"background" and not take focus from the workbook with dashboard.

anyone got a suggestion?
 
1. It's the same instance
2. maybe this:
....
application.screenupdating = false
x = activeworkbook.name
'open the files you want.
'after all the files are open then
windows(x).activate
....
 
Back
Top