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