topic Re: Exported Tables (*.xlsx) Corrupted in QlikView

Exported Tables (*.xlsx) Corrupted

cmccafferty — Wed, 12 Dec 2018 11:47:34 GMT

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! 😞

Re: Exported Tables (*.xlsx) Corrupted

m_woolf — Wed, 12 Dec 2018 12:43:34 GMT

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.

Re: Exported Tables (*.xlsx) Corrupted

cmccafferty — Wed, 12 Dec 2018 12:53:39 GMT

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]

Re: Exported Tables (*.xlsx) Corrupted

m_woolf — Wed, 12 Dec 2018 12:56:31 GMT

Change the .xlsx to .xls

Re: Exported Tables (*.xlsx) Corrupted

cmccafferty — Wed, 12 Dec 2018 13:15:36 GMT

Thanks, that worked.