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?
 
Top