Improve company productivity with a Business Account.Sign Up

x
?
Solved

OutputTo specify most recent Excel file format

Posted on 2007-11-20
1
Medium Priority
?
484 Views
Last Modified: 2013-11-27
I have the following line of code in my sub routine:
DoCmd.OutputTo acTable, "Tbl_qry_EOM_Results", acFormatXLS, "", True, "", 0

It outputs to Microsoft Excel 5.0/95 Workbok format and I would like it output to the most recent Excel.
0
Comment
Question by:TylerDerden
1 Comment
 
LVL 19

Accepted Solution

by:
frankytee earned 500 total points
ID: 20324634
use transferspreadsheet method
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Tbl_qry_EOM_Results", "c:\whateverfile.xls", True
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

605 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