Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Comment out these two lines:
set objSource = qvDoc.GetSheetObject(qvObjectId)
'Call objSource.GetSheet().Activate()
'objSource.Maximize
qvDoc.GetApplication.WaitForIdle
Comment out these two lines:
set objSource = qvDoc.GetSheetObject(qvObjectId)
'Call objSource.GetSheet().Activate()
'objSource.Maximize
qvDoc.GetApplication.WaitForIdle