Export by Macro

[#1]

Hi

I have created a macro that exports multiple objects to a single excel workbook.

However whenever the macro executes, all objects gets opened (if minimized) and maximized. How can I prevent this from happening?

I want to be able to export without any object opening up first.

[Chanty4u]

hi,

chk dis

Useful Qlikview Macros

[jonathandienst · Accepted solution]

Comment out these two lines:

set objSource = qvDoc.GetSheetObject(qvObjectId)

'Call objSource.GetSheet().Activate()

'objSource.Maximize

qvDoc.GetApplication.WaitForIdle