none
Is there a way to save a MS Access report to excel RRS feed

  • Question

  • I do not know visual basic.  If the answer requires visual basic, is there a resource you would recommend to learn it?  I would like to be able to save reports to excel and/or word.
    • Moved by Cindy Meister MVP Wednesday, November 18, 2015 3:31 PM not using vsto technology
    Tuesday, November 17, 2015 6:18 PM

Answers

  • >>>I do not know visual basic.  If the answer requires visual basic, is there a resource you would recommend to learn it?  I would like to be able to save reports to excel and/or word.

    According to your description, I suggest that you could use DoCmd.OutputTo Method (Access) that You can use the OutputTo method to output the data in the specified Access database object (a datasheet, form, report, module, data access page) to several output formats.

    You could refer to below code:

    Sub ExportReportToExcel()
    
    
        Dim sPath As String
    
        sPath = "D:\reports.xls"
    
        DoCmd.OutputTo acOutputReport, "Rpt_City", acFormatXLS, sPath, True
    
    
    End Sub
    

    Note: Exporting a Report to Excel you only see Microsoft Excel 5.0/95(*.xls) and excel 97-excel 2003 workbook(*.xls) as options

    For more information, click here to refer about DoCmd.OutputTo Method (Access)

    • Proposed as answer by David_JunFeng Thursday, November 19, 2015 1:33 AM
    • Marked as answer by David_JunFeng Wednesday, November 25, 2015 2:04 PM
    Wednesday, November 18, 2015 9:28 AM