Solved

OutputTo specify most recent Excel file format

Posted on 2007-11-20
1
468 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

813 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

15 Experts available now in Live!

Get 1:1 Help Now