Alternative for ActivateNext or Previous Window

[Rudi]

hi everybody,

In my workbook i have a macro which copies 'values' from 3 sheets to
another workbook.

To copy from and return i used ActiveWindow.ActivateNext or
ActiveWindow.ActivatePrevious.

This worked fine when the workbook was saved as .xls but not when it's saved as template (.xlt)

I read something about a Count property you can use to determine how many visible and hidden workbooks are open.

Can someone help me with an alternative way to 'switch' between 2 workbooks
even if other workbooks are opened at that moment?


Rudi

[Al Chara]

Try something like:
Windows("Book1.xls").Activate

Change the Window name to whatever you want.

[Rudi]

On 2002-04-17 13:46, Al Chara wrote:
Try something like:
Windows("Book1.xls").Activate

Change the Window name to whatever you want.

This works when the workbook is saved to .xls

when you save the workbook as template in the XLstart file the name will not be workbook but workbook1 when it's opened

[Rudi]

On 2002-04-17 13:46, Al Chara wrote:
Try something like:
Windows("Book1.xls").Activate

Change the Window name to whatever you want.

This works when the workbook is saved to .xls

when you save the workbook as template in the XLstart file the name will not be workbook but workbook1 when it's opened

[Al Chara]

You can try using AppActivate (probably won't work):

AppActivate "Microsoft Excel - Book1.xlt"

[Rudi]

On 2002-04-17 14:21, Al Chara wrote:
You can try using AppActivate (probably won't work):

AppActivate "Microsoft Excel - Book1.xlt"

Tried - but sofar no luck! thanks anyway

If the name of the active workbook, where the
'values' are to be copied from, could be refreshed at the start of the macro one could refer to that and the other workbook.