Results 1 to 3 of 3
  1. #1
    Coffee is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2011
    Location
    Australia
    Posts
    31

    Exporting a Access Report to an Excel File

    Hi.



    I want to export my report to an excel file exactly the same as the inbuilt method, but with a fixed path to save it...is this possible??

    Code currently using...

    stDocName = "saveReportFormat"
    DoCmd.OutputTo acReport, stDocName

    is there a way i can do this, but not have the save window pop up and have a hard coded file path??

    also i dont want to use...

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, reportName, theFilePath, True

    because this removes all formatting and only works on query's...unless there is a way to manipulate this code to save reports to file instead of queries?

    thanks in advance

  2. #2
    Coffee is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2011
    Location
    Australia
    Posts
    31
    Dont Worry Problem Solved!! For those of you wondering the code is..

    DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, "C:\Documents and Settings\User\Desktop\New Folder\saveReportFormat.xls", False

  3. #3
    killdozer is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Location
    New Brunswick
    Posts
    9
    Thanks, that was exactely what I was looking for.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 08-05-2011, 10:59 AM
  2. Exporting Report to a word file or PDF or whatever
    By AccessDatabaseGuy in forum Access
    Replies: 1
    Last Post: 05-03-2011, 02:03 PM
  3. Exporting query to Excel file with password?
    By jvera524 in forum Access
    Replies: 0
    Last Post: 12-06-2010, 11:24 AM
  4. Exporting to Excel Date Stamped File
    By BED in forum Import/Export Data
    Replies: 1
    Last Post: 08-07-2010, 05:53 PM
  5. Exporting a Report to Excel
    By bullwinkle55423 in forum Reports
    Replies: 0
    Last Post: 12-11-2007, 10:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums