I have a report that is best run as a pivottable in Excel. The data for the pivottable is a query I created in Excel based on data in an Access database. Before the query runs, I have some data manipulation I do in Access through a series of update queries, all tied together in an Access macro.
Does anybody know of a way to tie the Access macro to a button in the Excel spreadsheet? I'm trying to make this simple for the user. I don't want them to have to open both the Access file and the Excel spreadsheet to get the job done.