View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelnut1954 excelnut1954 is offline
external usenet poster
 
Posts: 175
Default Activate previous Workbook

I've been looking in here, and can't find what I'm looking for.
So.....

A macro within a workbook Original List 4-20-07.xls, will open up
anothe workbook,
Second List.xls. So, both will be opened with Second List.xls being
active. What I'm looking for is the command to switch back and
activate
Original 4-20-07.xls On the surface, it looks easy, but that
workbook name changes each day. So the macro will have to account for
the name change each day.

Isn't there a simple Previous command to switch it back to Original
*.xls ? I tried the wildcard, but it didn't work.

Thanks,
J.O.