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

Posted on 2007-04-03
Last Modified: 2012-06-27
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)?.
Question by:CPChem1
LVL 13

Expert Comment

ID: 18842996
Tools-Macro-Security and set to low.
LVL 39

Expert Comment

ID: 18843844
I can't find anything that controls this, not even in the registry.

Accepted Solution

ShesALive1 earned 500 total points
ID: 18845700
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.

Expert Comment

ID: 18961502
Thanks for the points, CP!

Author Comment

ID: 18961517
you bet cha!

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Correct ordering 16 48
Access recordset not updateable 8 38
Dateadd 3 22
DSum between dates 5 11
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now