Name Excel export file

[sergio0592]

Hi all,

I'am looking for achiveve this :

-i have a chart (sales per country), eg when i select Country=Russia and export chart to Excel i d like to have the Excel file already named Russia.xlsx

Do you think it's possible? Thanks

[QFabian · Accepted solution]

Hi @sergio0592 , sure you can do that... with a macro, can you use them?

If yes :

https://qlikviewmacro.blogspot.com/2012/01/export-to-excel-macro.html

that macro do a few things and save it as the name of the selected value, just right here :

ActiveDocument.Fields("REGION").Select val.Item(i).Text
        MyTable.ExportBiff  path & val.Item(i).Text &".xls"

[sergio0592]

Thanks!!