Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Tom,
Thanks for your perserverance - I am looking for the correct solution. I didn't look closely enough to your response to notice that you were using the 'xlApp' object in the 'Visible' and 'Workbooks.Open' commands. Once I included it in both, the dangling instance of 'Excel.exe' as a process in Task Manager properly clears. Thanks so much for your help, Tom. Regards, VBA Dabbler "Tom Ogilvy" wrote: It is obvious that you didn't try it, so apparently you not are looking for the correct solution. I tested your code and experienced the same problem - no surprise. I ran this code Sub TesterAA100() Dim xlApp As New Excel.Application Dim FileString As String FileString = "C:\MyDocuments\MyWorkbook.xls" xlApp.Application.Visible = True xlApp.Workbooks.Open (FileString) 'Focus is now on the workbook Set xlApp = Nothing End Sub and did not have the problem. If you want to reset then put the single statement END in your code. But that would be an ill advised solution. -- Regards, Tom Ogilvy "VBA Dabbler" wrote in message ... Tom, Thanks for your response. I've already tried this and it does not clear the process in TaskManager. Any other ideas? Thanks, VBA Dabbler "Tom Ogilvy" wrote: Dim xlApp As Excel.Application Dim FileString As String FileString = "C:\MyDocuments\MyWorkbook.xls" xlApp.Application.Visible = True xlApp.Workbooks.Open (FileString) 'Focus is now on the workbook set xlapp = Nothing -- Regards, Tom Ogilvy "VBA Dabbler" wrote in message ... 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 |