Close Excel through VBA

DrQuality

New member
Local time
Today, 23:45
Joined
Jul 16, 2002
Messages
6
I have this code here, which works, but doesn't close excel (which I thought oApp.Application.Quit was supposed to do...). So I'm wondering how I could actually close it! Thank you!

Dim oApp, oWB As Object
Set oApp = CreateObject("Excel.Application")
Set oWB = oApp.Workbooks.Open("W:\Working Directories\Mike\RegressThis.xls")
oApp.Application.Quit

- Mike
 

Users who are viewing this thread

Back
Top Bottom