when i run the simple macro below i get the following error at the Windows("macro test.xls").Activate line
run time error '1004' Activate method of Window class failed
i can activate open workbooks using this line of code in other macros though.Please Login or Register to view this content.
please can anyone explain why this is happening and suggest a solution?
Bookmarks