Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
maxime66
Creator
Creator

VBA Module - Quit Excel app

Hy Qlikers,

i use a small macro in Qlik, but since i work on Office 2013 ,Excel doesn't close at the end.

Does someone meet the same issue ?

Thx for your help.

Set objExcel = CreateObject("Excel.Application")

....

...

objExcel.Quit

objExcel.Application.Quit

1 Solution

Accepted Solutions
mightyqlikers
Creator III
Creator III

hi,

try some thing like this.

objExcel = nothing

objExcel.Application = nothing

$@M.

View solution in original post

3 Replies
mightyqlikers
Creator III
Creator III

hi,

try some thing like this.

objExcel = nothing

objExcel.Application = nothing

$@M.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

I've check in our macros and there is only one statement:

objExcel.Quit

After than goes the:

ActiveDocument.getApplication.sleep 5000

Nothing else.

maxime66
Creator
Creator
Author

Works fine !

thanks