Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have "the phantom app Excel.EXE" issue, addressed on Tushar's site.
It happened in code where I create a new instance of excel and do lots of stuff. I have tried qualifying everything. Finally boiled down to the following lies of code that will produce the problem.. The line that adds a workbook seems to be the problem, although I have tried everything I could think of, even pausing and manually opening a blank workbook....still get the phantom on closing. Thanks for the help... Option Explicit Public XLNEW As Object Public XLUser As Object Sub NEWAPPTEST() Set XLUser = GetObject(, "excel.application") Set XLNEW = CreateObject("excel.application") XLNEW.Workbooks.Add 'additional code here typically XLNEW.Workbooks().Close XLNEW.Quit Set XLNEW = Nothing set xluser = nothing End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Quit | Excel Programming | |||
vba advice how 2get a input box to quit by entering the word quit+ 4 a msgbox to disp | Excel Programming | |||
Quit | Excel Programming | |||
Excel Won't Quit | Excel Programming | |||
Exit-quit sub | Excel Programming |