Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

appExcel.ActiveSheet.SaveAs how to save in Excel 2003

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

1 Reply
stevelord
Not applicable

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

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. )