wellssh1
09-09-2006, 10:22 AM
Hello, I hope you can help me.
I have a series of linked workbooks that goes up the chain of command in my company. (example, managers workbook is linked to his supervisors books, Directors workbook is linked to his managers books, and the VP is linked to the Directors books)
The problem is, that in order for the VP to have the latest information, all the Managers and Directors (in that order) have to update their workbooks first (daily).
Without re-doing the entire project.............. I think what would work great (if even possible) would be for me to have a generic workbook that I control. Write code in this workbook to open all the managers workbooks, save and close them, then open the Directors workbooks, save and close them, then open the VP workbook, save and close it. Even better, have this done automatically in the middle of the night.
I have already turned off the "update links dialog box" so I just need the workbooks opened, saved and closed, but it has to open them in a specific order (all managers first, then all directors, then the VP)
Hope that made sence.
I am a VBA newbie, but understand some, so if you are willing to help figure this out, please provide as much information as is convienant or possible.
thanks in advance for any help given
I have a series of linked workbooks that goes up the chain of command in my company. (example, managers workbook is linked to his supervisors books, Directors workbook is linked to his managers books, and the VP is linked to the Directors books)
The problem is, that in order for the VP to have the latest information, all the Managers and Directors (in that order) have to update their workbooks first (daily).
Without re-doing the entire project.............. I think what would work great (if even possible) would be for me to have a generic workbook that I control. Write code in this workbook to open all the managers workbooks, save and close them, then open the Directors workbooks, save and close them, then open the VP workbook, save and close it. Even better, have this done automatically in the middle of the night.
I have already turned off the "update links dialog box" so I just need the workbooks opened, saved and closed, but it has to open them in a specific order (all managers first, then all directors, then the VP)
Hope that made sence.
I am a VBA newbie, but understand some, so if you are willing to help figure this out, please provide as much information as is convienant or possible.
thanks in advance for any help given