View Full Version : How do you access an open Excel app


Kenln
10-17-2006, 07:39 AM
I have some code that opens an excel app and fills it with data. From there I want to call one or another sub routine depending on what I want to do next. How do I refer to an already open Excel Application?

Do I have to Dim the Excel App; Workbook and Sheet again. I suppose I do??? But for the Excel App I don't think I want to:
Set My_Excel_App = CreateObject("Excel.Application")
because it is already open.

I could realy use some help on this one.

Thanks again.