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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <normanjo...@whereforartthou.com>
wrote:
> Hi J,
>
> Try :
>
> ThisWorkbook.Activate
>
> ---
> Regards,
> Norman
>
> "excelnut1954" <excelnut1...@yahoo.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > 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.