Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Save parametric excel

Hi all,

I need with a macro to save an excel created with the same macro in my document with a variable link, where the name of excel can change on the basis of an input button

Up to now i created the excel:

Sub excel

dim ExcelApp, ExcelWB
Set excelFile = CreateObject("Excel.Application")
excelFile.Visible = true
'ExcelApp.ScreenUpdating = false
'ExcelApp.DisplayAlerts=false
'Create the WorkBook
Set curWorkBook = excelFile.WorkBooks.Add
'Create the Sheet
'Save the excel in my document with a variable link, where the name of excel can change on the basis of an input button

End sub

Please help me,

Thanks in advance

Lorenzo

Tags (1)