vba programming

i am using transfer spreadsheet to export access table into excel file.. i am trying to enter the name of excel file to be stored using a text box and i am encountering problems when i am trying to make use of the value in the textbox.
so i am looking out for the code so as how to name the excel file before exporting

can anyone help me out in the above and your suggestions would be of great help to me