Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Exported Tables (*.xlsx) Corrupted

Anyone ever seen this message or know what I'm doing wrong?

The macro successfully downloads the files, but excel wont open them for me! 😞

4 Replies
Highlighted
Master II
Master II

Re: Exported Tables (*.xlsx) Corrupted

I believe that ExportBIFF results in a file in .xls format. You have specified that the file has a .xlsx extention, which doesn't match the file format.

Highlighted
Contributor III
Contributor III

Re: Exported Tables (*.xlsx) Corrupted

Thanks.

Any idea what I need to change it to?

[code]

sub Export_Trust

ActiveDocument.Sheets("ATC CM").Activate
set trust1 = ActiveDocument.GetSheetObject("CH205")
trust1.ExportBiff "X:\Business Performance\Finance\Cash\Download\QVATC.xlsx"

ActiveDocument.Sheets("Trust CM").Activate
set trust2 = ActiveDocument.GetSheetObject("CH210")
trust2.ExportBiff "X:\Business Performance\Finance\Cash\Download\QVTrust1.xlsx"
set trust3 = ActiveDocument.GetSheetObject("CH207")
trust3.ExportBiff "X:\Business Performance\Finance\Cash\Download\QVTrust2.xlsx"

end sub

 

[/code]

 

Highlighted
Master II
Master II

Re: Exported Tables (*.xlsx) Corrupted

Change the .xlsx to .xls

Highlighted
Contributor III
Contributor III

Re: Exported Tables (*.xlsx) Corrupted

Thanks, that worked.