Close Excel through VBA (1 Viewer)

DrQuality

New member
Local time
Today, 20: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
 

Fizzio

Chief Torturer
Local time
Today, 20:45
Joined
Feb 21, 2002
Messages
1,885
I think it should be

oApp.Quit
 

Users who are viewing this thread

Top Bottom