topic Re: Export Macro to Excel in QlikView

Export Macro to Excel

Anonymous — Thu, 02 Apr 2015 08:31:50 GMT

Hello,

I have this macro that exports the table in one excel's file, i want that excel's file Name keep the last value of one table's field.

For example: Field A: 2010;2011;2012 the name will be 2012.

Sub exportExel

dim ls_date

set ExcelSheetApp = CreateObject("Excel.Application")

ExcelSheetApp.Visible = false

set ExcelWB= ExcelSheetApp.Workbooks.Add

ExcelWB.Sheets(1).name = "Storico"

set XLSheet = ExcelWB.Worksheets(1)

set QVData = ActiveDocument.GetSheetObject("CH01")

set XLSheet = ExcelWB.Worksheets(1)

QVData.CopyTableToClipboard true

XLSheet.Paste XLSheet.Range("A1")

ExcelWB.SaveAs "C:\Users\ut0854\Desktop\Qlik Omicron\Diagnostico\Storico\NAME OF FILE.xlsx", 51

ExcelWB.Close

ExcelSheetApp.Application.Quit

End Sub

m_woolf — Thu, 02 Apr 2015 16:20:42 GMT

You might store the Max of field A in a variable and use the variable value in the macro to get the filename.

Anonymous — Fri, 03 Apr 2015 07:10:33 GMT

Ok thanks.

But after i have created the variable

varmax = Max(Date(DataComp1,'DD/MM/YYYY'))

How can i use the value of this variable in the macro?

m_woolf — Fri, 03 Apr 2015 10:54:08 GMT

This is from the API Guide:

set v = ActiveDocument.Variables("Variable1")

msgbox(v.GetContent.String)

Anonymous — Fri, 03 Apr 2015 13:44:57 GMT

thanks a lot

for your kindness