3 Replies Latest reply: Jul 26, 2012 5:51 AM by Johannes Sunden RSS

    Set path and file name using macro

      Hi,

       

              I am trying to copy a tablebox to excel sheets using macro. I want to set a default path as well as name for the excel sheets in the macro so that a .xls file is created at the same location. I am doing all this using CopyToClipBoard and paste options in VB. I dont want to use the export option of textbox. Can anybody suggest me something???

       

      regards,

      Rupali