Access 2010: Using VBA to xport table to Excel, then modify the excel workbook externally? RRS feed

  • Question

  • I've got some tables in Access which I export to Excel using VBA. Once exported, I'd like to add some pivot tables, special formatting and formulas into the workbook.  Any idea how to do this?  Here are some specific tasks after the export:

    1. Insert a pivot table into a 2nd sheet.  The pivot table will have a filter field.

    2. Format the column widths in that pivot table and add some conditional cell colors

    Anybody know how to code this?   I assume I'll need to export from access then open the excel file and use excel object model from within access?


    • Edited by Geek 2016 Tuesday, February 24, 2015 10:00 AM
    Tuesday, February 24, 2015 9:59 AM


All replies