Hi,
I have my VBA Codes set in a workbook (Production) that my supervisors open to calculate production. So when they open the workbook (Production) I have a button that they push that starts the code however I need to put something in that activates the other open workbook, The problem is that the name of the workbook that they run the code on can change.
How can I make the other open workbook activate.
Any Ideas?
Thank You, Mike
Last edited by realniceguy5000; 05-29-2009 at 03:11 PM.
I was able to get this small script to do what I needed. Somehow it ends up on the other open workbook.
So the script works now.
Thank You, Mike
Please Login or Register to view this content.
I was wrong again. This is close to what I need but not working as expected in the live version.Originally Posted by realniceguy5000
I was able to get this small script to do what I needed. Somehow it ends up on the other open workbook.
So the script works now.
Thank You, Mike
Please Login or Register to view this content.
For some reason the script starts on the production sheet then finds the next open workbook then returns to the production sheet again. I need the script to exit when the next open workbook is found?
Thank You,Mike
I know this is an old post, but I came across it while searching for this exact thing.
If you only have two workbooks open at the time, then this should work. Basically, this will note the name of the active workbook and then compare the name as the active workbook changes. If the name is different, then it will exit sub.
Please Login or Register to view this content.
Last edited by pclive; 08-13-2010 at 04:09 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks