Thread: Active workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jimmy Jimmy is offline
external usenet poster
 
Posts: 11
Default 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