1 Reply Latest reply: Mar 29, 2011 3:56 AM by Miguel Angel Baeyens de Arce RSS

    how to save to a new file when file already exists in VB?


      I don't have much knowlegde of VB and i'm trying to save an exported excelfile without overwriting the other.

      sub export
      set MyTable = ActiveDocument.GetSheetObject("CH21")
      MyTable.ExportEx "C:\temp\overview_1.xls",5
      end sub

      that's the code behind my button so each time i press it i want to create an overview_2, overview_3, ...
      pls help :)