Edited to remove request for email. See Rule 10–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.
Thanks
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
