Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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?