Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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