Creating Worksheets from Existing Excel Instances in VB.NET?

[leeedw]

Hi everyone,

I use the following code whenever I export to Excel from VB.NET

objExcel = New Excel.Applicati on()
objWorkBooks = objExcel.Workbo oks
objWorkBook = objWorkBooks.Ad d
objWorkSheet = objExcel.Active Workbook.Active Sheet

The problem is that every time I need to export, it results in creating
a new instance of Excel in memory. Excel is a bit of a resource hog,
and suffers from memory leaks. Is there a way to open another
worksheet from an Excel process/instance that is already running if
there is one?

How would I do this?

Thanks!

[+Vice]

If objExcel is nothing then
objExcel = New Excel.Applicati on()
End if

Use that code and you won't generate a new Excel application every time.

<le****@hotmail .com> wrote in message
news:11******** *************@j 33g2000cwa.goog legroups.com...

Hi everyone,

I use the following code whenever I export to Excel from VB.NET

objExcel = New Excel.Applicati on()
objWorkBooks = objExcel.Workbo oks
objWorkBook = objWorkBooks.Ad d
objWorkSheet = objExcel.Active Workbook.Active Sheet

The problem is that every time I need to export, it results in creating
a new instance of Excel in memory. Excel is a bit of a resource hog,
and suffers from memory leaks. Is there a way to open another
worksheet from an Excel process/instance that is already running if
there is one?

How would I do this?

Thanks!

[leeedw]

objExcel is not a global variable and only accessible in this function.
If Excel is already opened manually by the user I would like to use
that instance as well. Is there a way to attach to an existing
process?

+Vice wrote:

If objExcel is nothing then
objExcel = New Excel.Applicati on()
End if

Use that code and you won't generate a new Excel application every time.

<le****@hotmail .com> wrote in message
news:11******** *************@j 33g2000cwa.goog legroups.com...

Hi everyone,

I use the following code whenever I export to Excel from VB.NET

objExcel = New Excel.Applicati on()
objWorkBooks = objExcel.Workbo oks
objWorkBook = objWorkBooks.Ad d
objWorkSheet = objExcel.Active Workbook.Active Sheet

The problem is that every time I need to export, it results in creating
a new instance of Excel in memory. Excel is a bit of a resource hog,
and suffers from memory leaks. Is there a way to open another
worksheet from an Excel process/instance that is already running if
there is one?

How would I do this?

Thanks!