Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
hasdur
Posted - 03/15/2012 : 06:41:44 AM Hi,
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.
Thanks for your help
2 L A T E S T R E P L I E S (Newest First)
Hideo Fujii
Posted - 03/22/2012 : 12:45:32 PM 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:
save -t %H %Y\temp; win -t wks %Y\temp;
--Hideo Fujii OriginLab
Penn
Posted - 03/15/2012 : 09:16:31 AM Hi,
You can use the script below:
string firstBookName$ = %H; // get the name of current book
newbook; // create a new book
win -a %(firstBookName$); // activate the first book