What happens if you do something in that instance?

Option Explicit
Sub testme()
Dim xlApp As Object
Dim xlWkbk As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlWkbk = xlApp.Workbooks.Add
End Sub

If you don't want that empty workbook hanging around:

Option Explicit
Sub testme()
Dim xlApp As Object
Dim xlWkbk As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlWkbk = xlApp.Workbooks.Add
xlWkbk.Close savechanges:=False
End Sub





moglione1 wrote:

Thank you very much for your response but that does not QUITE work.

Basically it does open the other instance of EXCEL. But then it closes
it back down.

Anyway around this at all. I am new to VBA so dont fully understand it
yet.

Thank you very much

--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=480809

--

Dave Peterson