Activate previous Workbook

[excelnut1954]

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.

 

[Norman Jones]

Hi J,

Try :

ThisWorkbook.Activate

 

[excelnut1954]

Hi J,

Try :

ThisWorkbook.Activate

---
Regards,
Norman









- Show quoted text -

Thanks, Norman.
Too easy. I'm not going to figure anything out that's too easy.
Thanks again.
J.O.