getting the below error when tring to export data from qlikview application

[Anonymous]

Hi All ,

I am getting the below error when tring to export data from qlikview application , Can anyone please advice me how do i resolve the issue.its urgent

Macro Parse Failed : functionality was lost

Export2XL_Multisheet

Error :subscript out of range

[m_woolf]

What does your macro look like?

[ashfaq_haseeb]

Hi

Do you used macro to export Excel or you directly export.

Can you post your macro here.

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

you can use this macro for export.

1. sub Export 
2.     set XLApp = CreateObject("Excel.Application") ' Define Object 
3.         XLApp.Visible = True 'Visible set as true 
4.         set XLDoc = XLApp.Workbooks.Add 'Open new workbook     
5.         set table = ActiveDocument.GetSheetObject("TB04") 
6.         rem set table = ActiveDocument.GetSheetObject("MB01") 
7.          
8.     set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted 
9.         table.CopyTableToClipboard true 'Copy data to Clipboard 
10.         XLSheet.Paste XLSheet.Range("A1") 'Paste data into cell 
11.      
12. end sub 

Regards

ASHFAQ

[#5]

Hi!

I have the same error.

The ExportToExcel macro worked for Excel 2010 and ,now, it does not work for Excel2013.

Any idea on how to solve this?

Or any suggestions on what it is different in Excel 2013 that could effect the macro function?

Cristina Jianu