Questions about opening a workbook in code
 

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?

Questions about opening a workbook in code
 

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
....

--
MacGuy


"DawnTreader" wrote:

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?