Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active workbook
HI gan
I used recorder to record macro. I Switch from the active WB to another WB and then want to switch back. How do I make this generic to go back to previous workbook. The recorder is specific to the files that I had open at the time Windows("Book3").Activat My Cod Windows("040403.xls").Activat Book3 is a good reference but I need the 040403 reference to be (Back to previous Window Thank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active workbook
Windows("Book3").Activate Set origWB = ActiveWorkbook My Code Windows("040403.xls").Activate origWB.Acrtiate -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Jimmy" wrote in message ... HI gang I used recorder to record macro. I Switch from the active WB to another WB and then want to switch back. How do I make this generic to go back to previous workbook. The recorder is specific to the files that I had open at the time. Windows("Book3").Activate My Code Windows("040403.xls").Activate Book3 is a good reference but I need the 040403 reference to be (Back to previous Window) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
How do I make an open workbook the active workbook | Excel Programming | |||
Copy from active workbook to new workbook. | Excel Programming | |||
Copy Modules from One workbook to Active Workbook | Excel Programming | |||
Preventing opening workbook inside active workbook. | Excel Programming |