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