Exporting to excel

  • Thread starter Thread starter philippe_b
  • Start date Start date
P

philippe_b

Hi everyone !

I have a vba function to export a table to excel. That's great !
Is there a code to allow the user to choose where to save this
spreadsheet and what name to give it.
 
Hi Philippe,

what is the code you are using to export the table?

If you are using TransferSpreadsheet, the parameter FileName can (and
should) include the file path.

DoCmd.TransferSpreadsheet
TransferType
, SpreadsheetType
, TableName
, FileName
, HasFieldName
, UseOA

If you want the user to be able to Browse to a directory, check out this
link by Stephan Lebans:

http://www.lebans.com/callbackbrowser.htm




Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
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

How to Export Gmail Emails to PST Format? 6
Export to Excel 3
export to excel and save 4
Exporting to Excel from Access 3
Calculate Totals in Spreadsheet 2
Automating export to Excel 4
Import to many to many table 7
How can we convert OST to PDF file format? 1

Back
Top