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.
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.