How come everyone's asking about C# these days? I don't know how to use
C#, but I'll tell you the VB/VBA way, and hopefully you can figure out
how to use it.

Creating a new Excel instance is done this way:

Set ExcelApp = CreateObject("Excel.Application")

Accessing the currently open Excel instance is done similarly:

Set ExcelApp = GetObject(,"Excel.Application")

If there are multiple instances, I don't know how to specify which one
to use.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

sbriscoe < wrote:

Hi
I am just creating a new instance of the Excel application to use...

ExcelApp = new Excel.Application();

How would I get reference to the current Excel application in C#?


---
Message posted from http://www.ExcelForum.com/