Results 1 to 1 of 1
2002-02-21, 14:31 #1
- Join Date
- Feb 2001
- Louisville, Kentucky, USA
- Thanked 0 Times in 0 Posts
Not for the Faint@Heart (Access 97)
Edited to remove request for email. See <!rule=10>Rule 10<!/rule>--Charlotte
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.OpenQuery "dltRepFollowUp", acNormal, acEdit
DoCmd.SetWarnings TrueRoberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>