Export to Excel with Filter Options

[dcoley]

Hi. I'm new here to please bear with me. I have an access macro that exports four separate queries to one excel workbook. One of the queries is a year to date (YTD) query. My user needs to see the current year to date in the excel spreadsheet, BUT they also need the option to select a previous year at any given time. My initial thought was to export ALL data with a year column and just let them filter the database by year. If I do this, however, I would like for the Excel spreadsheet to already have that year column have the filter option turned on. The ideal situation would be for there to be a link to each year (depending on the data present) and when clicked that link will filter the spreadsheet for that year only.



Any thoughts and suggestions are greatly appreciated!!

[June7]

Have you considered setting the data link on the Excel side?

Otherwise, would have to open the Excel as a VBA object and manipulate the worksheet settings.

Why Excel and not just view data in Access form or report?