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
|