Extracting data from Access to create a pivot table in excess

[perksyno1]

Hi there,

I've got a problem I was hoping someone may be able to help with. I need to get some data from access and use it to create a pivot table in an excel file.

I've recorded myself doing this but the access database name changes monthly so I was hoping there would be some code where as I can choose which access data base to get the data from?

Thanks

Mark