Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch Workbooks
I am looking for a statement that will allow me to switch
between open workbooks using a string variable with a temp name. What I am trying to use, but can not get to work is; tmpName2 = Left(ActiveWorkbook.Name, Len ActiveWorkbook.Name) - 13) Windows("tmpName2.xls").Activate Any suggestions would be very much appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch Workbooks
Why not just use
tmpName2 = ACtiveworkbook.Name -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Ronbo" wrote in message ... I am looking for a statement that will allow me to switch between open workbooks using a string variable with a temp name. What I am trying to use, but can not get to work is; tmpName2 = Left(ActiveWorkbook.Name, Len ActiveWorkbook.Name) - 13) Windows("tmpName2.xls").Activate Any suggestions would be very much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using ALT-TAB to Switch Between Spreadsheets | Excel Discussion (Misc queries) | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
Using alt-tab to switch between Excel workbooks under the same session | Excel Discussion (Misc queries) | |||
Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
Switch between workbooks | Excel Programming |