Save parametric excel

Tue, 26 Sep 2017 09:05:12 GMT

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

topic Save parametric excel in App Development

Save parametric excel