MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Call Excel and open new worksheet in existing instance?

Posted by P. Syverson on January 05, 2001 11:29 AM

We have a program that exports data to a file and then calls Excel loading the file data. It now opens a second copy of Excel instead of opening a new worksheet in the existing Excel instance. Does anyone know of a switch to open the existing instance of Excel???

Posted by Ed on January 06, 2001 7:49 AM

This code has worked for me:

Workbooks.Open FileName:="C:\FILENAME.xls"