Discussion Board for collaboration related to QlikView App Development.
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! 😞
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.
Any idea what I need to change it to?
ActiveDocument.Sheets("ATC CM").Activateset trust1 = ActiveDocument.GetSheetObject("CH205")trust1.ExportBiff "X:\Business Performance\Finance\Cash\Download\QVATC.xlsx"
ActiveDocument.Sheets("Trust CM").Activateset 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"
Change the .xlsx to .xls
Thanks, that worked.