Solved

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

Posted on 2007-04-03
5
416 Views
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)?.
0
Comment
Question by:CPChem1
5 Comments
 
LVL 13

Expert Comment

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

Expert Comment

by:stevbe
ID: 18843844
I can't find anything that controls this, not even in the registry.
0
 
LVL 1

Accepted Solution

by:
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.
0
 
LVL 1

Expert Comment

by:ShesALive1
ID: 18961502
Thanks for the points, CP!
0
 

Author Comment

by:CPChem1
ID: 18961517
you bet cha!
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Creating and Managing Databases with phpMyAdmin in cPanel.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

831 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