locked
MS Access 2010 Reports to Excel 2010 RRS feed

  • Question

  • HI,

    I am recently converting my MS Access 2003 Applications to MS Access 2010. In one of my application the reports are getting saved in Excel workbook.

    I need to save my Excel workbook in 2010 as per the requirement.  It is getting saved in 2010 format but datas are not there and throwing some errors.

    Could any one please help me out to save my reports in EXCEL 2010 format

    DoCmd.OutputTo acOutputReport, CboReportList.Column(2), "MicrosoftExcel(*.xlsx)", pathName & CboReportList.Column(2) & ".xlsx", False, ""

    Thanks.

    Thursday, November 13, 2014 4:27 AM