Edited to remove request for email. See <!rule=10>Rule 10<!/rule>--Charlotte

OK...here goes...

Below is code I am currently working on but would like to add a twist to it.

I'm using a form, w/o a recordset. I have a button and a text box(text) on the form. The button holds the code, the text box will hold a value input by a user.

Assuming I open the form and input "020202" in the text box. I want THAT value to be applied to code and naming the new spreadsheet. When the code runs, it exports to a spreadsheet with specific data. I want it to SAVE the spreadsheet with a name like...RFU020202.xls. If I input 0203002 in the text box I want the name of the spreadsheet to be RFU020302, etc.

I hope this was clear and someone can help me.

I appreciate any and all who can help.


Dim strExportDate As String
strExportDate = Me!txtExportDate

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "tblRepFollowUp", "c:My Documentstestexport.xls", False, 0
DoCmd.SetWarnings False
DoCmd.OpenQuery "dltRepFollowUp", acNormal, acEdit
DoCmd.SetWarnings True