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
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