Hi there,
I want to be able to open multiple work books at the same time.
so I have a master excel file called "Start". I have three other excel files called "book1", "book2" and "book3".
When I open "start" i want the other three files to open automatically. All files will be kept in the same folder.
cheers,
Easty
In "start", right click on any tab and "View Code". Then click on "this workbook" in the Project Explorer. Paste this code (modified with your path and your workbook names)Does that work for you?
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Chemistb
all sweet.....
cheers,
easty
Last edited by easty; 08-30-2010 at 09:00 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks