How to change default MS Access 2003 File Export "Save As Type" to Excel 97-2003

Since going over to MS Access 2003, saving a datasheet via File > Export, defaults to the "Save As Type" fo MS Office Access. How do we change this default to  Excel 97-2003 9*.xls)?.
CPChem1Asked:
Who is Participating?
 
ShesALive1Connect With a Mentor Commented:
Hi CP,

Create a macro or code (runcommand, sendkeys, etc...) to bring up the export dialog box exactly the way you want it.  Then customize menu. Add your macro and remove the default command.
0
 
wiswalldCommented:
Tools-Macro-Security and set to low.
0
 
stevbeCommented:
I can't find anything that controls this, not even in the registry.
0
 
ShesALive1Commented:
Thanks for the points, CP!
0
 
CPChem1Author Commented:
you bet cha!
0
All Courses

From novice to tech pro — start learning today.