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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel macro starting excel but nothing more..?

HI,

Trying to use a really simple macro I used before on other systems...



set XLApp = CreateObject("Excel.Application")

XLApp.Visible = True

set XLDoc = XLApp.Workbooks.Add

XLApp.Worksheets.Add

.... Excel (2010) opens and then just sits there.. no workbook, no worksheet, nothing..?

(security settings all on in the macro screen)

I have searched thru excel options and disabled every security setting I can see might effect this, but still no joy.

Has anybody experience this before please ?

Thanks in advance

Bob

1 Reply
struniger
Creator
Creator

This is just happening to me as well.

Looks like Doc.GetApplication.WaitForIdle is the culprit at least for some of the problem.

Now I can export using the QV fat client, but via the web interface and the IE plugin I still get the same behaviour.

Did you ever find a solution for this?