Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?