Changing a Name for an Export

  • Thread starter Thread starter C. Hernandez
  • Start date Start date
C

C. Hernandez

I need to have a data extract renamed by a user. Is there a way to have a
exported file from Access be named from text typed into a combo box?
 
Sure. Capture the name from the text box in your TransferSpreadsheet
method. This is not possible with a macro by the way. You'll need to
switch to VBA.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"SourceTableOrQueryName", Me.txtFileName, True

Me.txtFileName refers to the form field.
 
Hi Larry. Nice to hear from you. I really miss the MVP group. We moved
back into our house December 20th. I still haven't replaced my computers
because I don't have any place to put them. But I'm baaaaaaaaaaaack :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Linux extract data from .MDB file, and output to text ? 1
Export to Excel 3
Exporting design view tables 0
Convert Access 2007 to 2003 errors 1
Rounding difference in Access 2003 text exports 2
export to xml 1
VBA - retrieve data on last create named range from previous inserted named range 0
Text box names appear in report exported to Word 1

Back
Top