Solved

OutputTo specify most recent Excel file format

Posted on 2007-11-20
1
470 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 125 total points
ID: 20324634
use transferspreadsheet method
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Tbl_qry_EOM_Results", "c:\whateverfile.xls", True
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

808 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