Default "Save As Type" when Exporting

J

jhrBanker

I periodically export a number of Access Tables to an Excel file. For each
table that I export, I need to change the "Save As Type" to Microsoft Excel
97-2003. It's a bit annoying and time-consuming. Is there some way that I
can change the default "Save As Type" to Excel, or get Access to default to
the last value selected (which, if I remember correctly, it did in previous
versions)?
Thanks for your help.
 
J

John Nurick

I don't think there's a way to change the default - but why not write a
VBA procedure that uses DoCmd.TransferSpreadsheet to do the exporting
for you?
 

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

Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0
Saved Export List 1
Word 2010: trouble saving font/size 9
Cross-reference Insert Default Change 0
Export Access pivot table to Excel 0
Need help modifying code 0
Export to Excel Error "Cannot expad named range. 0
Error Saving Import/Export Spec 1

Top