I'm looking for a way to change the active book. I program some script, but my first issue is when I need a newbook, the newone became active. In this way, the end of my script can't be effective in the first book.
To summarize, I'm looking for a way to create a newbook and let the first book active, or choose the active book.
just a tip for readers of this thread who might be interested in....
If you want to make a new workbook with the same structure to the original - with same number of sheets, sheet names, column names comments, etc., maybe the just the following two lines may be quickest and easiest:
Changing the active book
Posted - 03/15/2012 : 06:41:44 AM
