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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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