Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]
Change the .xlsx to .xls
Thanks, that worked.