Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why not use CreateObject in all cases? Versus hijacking and quitting an
existing Excel instance. In any case, for starters, try flipping: Set xlapp = Nothing xlapp.Quit To xlapp.Quit Set xlapp = Nothing You're trying to control an object variable which you have terminated from memory. Great comments. I'll try both suggestions. Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Global replace a reference to a worksheet | Excel Discussion (Misc queries) | |||
Need to avoid a circular reference... | Excel Worksheet Functions | |||
How to Reference Global Variable for external application. | Excel Programming | |||
Quitting Excel without saving | Excel Programming | |||
Global file reference change | Excel Programming |