Hello ?? anyone can help me, please.
How to Automatic open others Workbook when we opened the Master Workbook.
Examp. :
I have a workbook (Master.xls), and when this file be opened, and then others workbook (Transactions.xls, Order.xls, etc.) is opened too.
Thank's before..
Last edited by antoni; 08-28-2009 at 10:05 PM.
Place this in the ThisWorkbook module of Master.xls
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi
try the following codes. change filenames and no of files in the code to suit your case.
RaviPlease Login or Register to view this content.
Hello, thank's for all...
But how to check a file was opened or not, and if not opened then appear message box. Because sometimes the user close some file.
Examp. : When open file Master.xls, other file like Transaction.xls, Order.xls, etc are opened too. But sometime user close some file like Order.xls.
And when we doing transaction in Master.xls, then must check these file or all file is opened or not.
Thank's
You can do a TRUE/FALSE check to see if the file is currently open, like this:
Now that you've seen that method, your could do it in only two lines of code, a little harder to read, but it's the same thing in half the steps:Please Login or Register to view this content.
Please Login or Register to view this content.
Hello Mr. JBeaucairethank's for your helps. Nice code bos!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks