Answer to "Excel Report Dump" Question

N

Nick

Here is the code that will perform this action (in case someone else needs
to do this):

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3,
"YourQyeryName", "Path to your file and filename", True

Best,

Nick
 
P

PC Datasheet

See my response to your previous post!


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Report with Graph to Excel error 2495 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Problem Exporting to xls File 3
Word macro that can call cells out of Excel for a find and replace 0
VBA - exporting serial letters to single documents 0
WORD VBA Search and switch to advanced ... 1
VBA code issue...Would love expert help. 5
Run time Error 2220 2

Top