appExcel.ActiveSheet.SaveAs how to save in Excel 2003

Tue, 02 Jul 2013 20:44:37 GMT

Hi all... i've to export one table from qlikview to excel; i've done one macro that do the job in a correct way but the file created is in 2010 format (xlsx).

Now i've to open this file with a 2003 version of excel (.xls), modify it and then reload in qlikview.

i'd like to know if there is a way to specify the format of the file to export.

best regards

Andrea

Re: appExcel.ActiveSheet.SaveAs how to save in Excel 2003

stevelord — Tue, 02 Jul 2013 21:05:11 GMT

Fear I have an answer for this. You should be able to just switch the .csv in my code below with a .xls or add an &".xls" to the end of the filename in your script.

If you' use the same vb type code I have below, you can specify the file extension where you specify the file name and it works. There might be something like that on whichever code protocol you are using too. (I hadn't played with this script in a month, but I pushed the button just now and the file came out with today's date in the name and .csv format.)

Here is macro code I have on an export to file button in one of my files.

Sub Test

set obj = ActiveDocument.GetSheetObject("TB02")

File = "C:\users\steve\desktop\"&"Test "& DatePart("YYYY", Now()) & "-"& DatePart("M", Now()) &"-"& DatePart("D", Now()) & ".csv"

obj.Export File, ","

(I had it up to emailing the file, but I broke that by accident and lost the backup so fell back to this straight export for now. )

topic appExcel.ActiveSheet.SaveAs how to save in Excel 2003 in QlikView

appExcel.ActiveSheet.SaveAs how to save in Excel 2003

Re: appExcel.ActiveSheet.SaveAs how to save in Excel 2003