Excel macro starting excel but nothing more..?

Wed, 24 Apr 2013 14:51:00 GMT

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

Re: Excel macro starting excel but nothing more..?

struniger — Tue, 14 Jul 2015 09:06:56 GMT

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?