Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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?