Hi,

Can anyone please help me with a macro to switch between two opened excels without opening them again.

Thanks
Justin

Do you mean two separate copies of Excel? Use Alt+Tab. Otherwise you'll need to use Windows API calls to find the second instance of Excel (someone correct me if I'm wrong).

__________________
Regards,
JP
JP SoftTech

If you are looking at making some workbook active you can do that by

Workbooks("Sample 1.xls").activate

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thanks Shasur.. It works! :)

Justin

by activating in your macro shell program