Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do you clear an object from the VBProject once it has served its
usefulness? I've done the following: 1. Opened a workbook from a Word VBProject with the following code: Dim xlApp As Excel.Application Dim FileString As String FileString = "C:\MyDocuments\MyWorkbook.xls" Excel.Application.Visible = True Workbooks.Open (FileString) 'Focus is now on the workbook 2. Closed workbook by closing Excel I've found that there is still an instance of the an object reference to the Excel app - there is the "Excel.exe" process in the Windows Taskmanager. I've found that when I reset the VBProject where the above code resides, the instance is cleared and the "Excel.exe" process in the Windows Taskmanager is removed. Do you know how to selectively clear the instance of the object reference in the VBProject? Thanks, VBA Dabbler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
Unprotecting the VBProject | Excel Programming | |||
Documentation for VBProject | Excel Programming | |||
VBProject events? | Excel Programming | |||
VBProject events? | Excel Programming |