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.

Hi J,

Try :

ThisWorkbook.Activate


---
Regards,
Norman



"excelnut1954" wrote in message
ps.com...
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.

On Apr 20, 1:56 pm, "Norman Jones"
wrote:
Hi J,

Try :

ThisWorkbook.Activate

---
Regards,
Norman

"excelnut1954" wrote in message

ps.com...



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.- Hide quoted text -

- Show quoted text -

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