Open all files in a folder

D

Daniel Van Eygen

I have a folder that contains 3 workbooks. I open those workbooks
automatically from the desktop with a shortcut to Excel.
I need to control the sequence of opening those files as the main file
depends on the information contained in the 2 other workbooks.
How can I control the sequence and how can I make a certain page active at
opening each file?
Can I get rid of the update question? The file always has to be updated.
Thanks for your valued help.
 
T

Tom Ogilvy

If they are linked, the order shouldn't be an issue. When they are all
open, I would think the links would be updated. In the workbook_Open event,
you could possibly have the main workbook check if the other two are opened,
and if not open them.
 
D

Daniel Van Eygen

Thanks Tom,
Opening and updating is not the problem. I need excel to show the "main"
workbook at the first page when it is done opening and updating all 3 files.
At this moment it is displaying one of the other files. It is a matter of
controlling in what sequence the files are opening. I think if I can get
Excel to open the "main" workbook last than it will display as saved
before...?
Daniel
 
T

Tom Ogilvy

The obvious solution is to not leave things to chance. If you need to
control how they are opened, have the shortcut open one workbook and have
that workbook use its workbook_open event to control all other actions - so
that when the code is complete, you are presented with the layout and
situation you require. .
 
L

Lynn A.

Have you tried using a workspace?

File, Save Workspace.

Each file is opened and positioned on the layer that you want.

Lynn
 
D

Daniel Van Eygen

Thanks Tom,
I used the workbook_open event and all works fine, exactly as I want. Guess
I needed a little push...
Thanks
 
Top