Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies