| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open all files in a folder
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open all files in a folder
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. -- Regards, Tom Ogilvy "Daniel Van Eygen" wrote in message i.nl... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open all files in a folder
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 "Tom Ogilvy" wrote in message ... 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. -- Regards, Tom Ogilvy "Daniel Van Eygen" wrote in message i.nl... 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open all files in a folder
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. . -- Regards, Tom Ogilvy "Daniel Van Eygen" wrote in message i.nl... 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 "Tom Ogilvy" wrote in message ... 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. -- Regards, Tom Ogilvy "Daniel Van Eygen" wrote in message i.nl... 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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open all files in a folder
Thanks Tom,
I used the workbook_open event and all works fine, exactly as I want. Guess I needed a little push... Thanks "Tom Ogilvy" wrote in message ... 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. . -- Regards, Tom Ogilvy "Daniel Van Eygen" wrote in message i.nl... 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 "Tom Ogilvy" wrote in message ... 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. -- Regards, Tom Ogilvy "Daniel Van Eygen" wrote in message i.nl... 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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open all files in a folder
Have you tried using a workspace?
File, Save Workspace. Each file is opened and positioned on the layer that you want. Lynn "Daniel Van Eygen" wrote in message li.nl... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Open Certain Excel Files in Folder | Excel Discussion (Misc queries) | |||
| Open Excel files in a folder | Excel Programming | |||
| Open Excel files in a folder | Excel Programming | |||
| How do I get series of files to open from same folder | Excel Programming | |||
| open all files in a folder and ... | Excel Programming | |||
Hybrid Mode
