Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Saved Exports to Excel (2007)

    I'm trying to export information from Access 2007 to Excel 2007 and then have an Auto_Open macro run in Excel. Therefore, the spreadsheet has to be an .xlsm file in order to contain macros. When beginning the export from Access a dialog box asks me to select the destination for the data you want to export. My only choices are .xls, .xlsx and .xlsb. The only work around I can figure is to save to txt file and then have my Auto_Open macro import the text file each time.

    Is there an easier way?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Saved Exports to Excel (2007)

    Sorry to be so late in replying. One approach you might consider is using VBA in Access to export the data to Excel, and then open the Excel file using Automation. It requires more code but would eliminate the interim step.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts