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???