Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

closing a vb excel object

Status
Not open for further replies.

scro11bar

Programmer
Oct 25, 2001
11
US
I am doing somethings to a excel file and when I close the excel object by excel_app.quit, the excel object or the workbooks or worksheets doesnt seem to close. I was wondering if there was a way to completely close all objects associated with the excel object and the excel objects itself. Thanks in advance.

G. Rush
 
also use the following stmt after quitting excel

excel_app.quit
set excel_app = nothing

Hope this should resolve the issue
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top