Export excel

Tue, 26 Jul 2011 12:59:05 GMT

HI all,

I use the following code to export tables objects to an excel sheet.

It works with Qlikview Desktop, when i try to export from IE9 (with the plug-in). I have this message :

Failure analysis of the macro. Functionality has been lost.

exportExcel

Error. An ActiveX component can not create object: 'Excel.Application'

The message box has "QlikOcx' as title.

Thanks for your help

Regards

Gilles REMY

sub exportExcel
'Open Excel
set XLApp = CreateObject("Excel.Application") ' Define Object
XLApp.Visible = True 'Visible set as true
set XLDoc = XLApp.Workbooks.Add 'Open new workbook

'récupération tableau VL
set VL = ActiveDocument.GetSheetObject("tableVL")
'Copie du tableau dans la feuille Excel
set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted
VL.CopyTableToClipboard true 'Copy data to Clipboard
XLSheet.Paste XLSheet.Range("A1") 'Paste data into cell

'récupération tableau PL et INDUSTRIE
set PLI = ActiveDocument.GetSheetObject("tablePLI")
set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted
PLI.CopyTableToClipboard true 'Copy data to Clipboard
XLSheet.Paste XLSheet.Range("A28") 'Paste data into cell

'récupération tableau TOTAL
set TOTAL = ActiveDocument.GetSheetObject("tableTOTAL")
set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted
TOTAL.CopyTableToClipboard true 'Copy data to Clipboard
XLSheet.Paste XLSheet.Range("B52") 'Paste data into cell
end sub

Export excel

m_woolf — Tue, 26 Jul 2011 13:44:44 GMT

Is the OCX set to system level macro access?

Export excel

Tue, 26 Jul 2011 14:17:12 GMT

Hi,

In the macro utilty, I have

Security level set to : System Access
Active Local Security : Allow sytem access

Best regards

Gilles

Export excel

m_woolf — Tue, 26 Jul 2011 19:57:11 GMT

Open the app from the accesspoint and press Shift+Ctrl+M to see how the macro security level is set.

Export excel

Thu, 13 Oct 2011 14:56:39 GMT

Hello Gilles-REMY,

I had this same problem and only solved by uninstalling and installing office again.

regards,

Gleybson Fernandes

topic Export excel in QlikView

Export excel

Export excel

Export excel

Export excel

Export excel