0 Replies Latest reply: Sep 26, 2017 5:05 AM by Lorenzo Capanna RSS

    Save parametric excel

    Lorenzo Capanna

      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