Run Macro to generate report in Access from excel data, then print PDF from Excel?

Hi
I have set up a link between Excel and Access, so that I can create the report, however I want to be able to press a button in excel, say in a Tab called January, that will run a macro that looks in access for that linked table, generate the report, Hopefully behind the scenes, then open in PDF in Excel for printing or saving...

I'm being picky and think the access reports look "Prettier"

OR

I have managed to create a macro in Access to do the report part automatically, is there a way to import or put this macro into excel????

Is this possible, I am fairly new to using VBA and Macros, so any solutions, very gratefully accepted..

Thanks

This might get you started but you might have to google the syntax.

(New Module)

Please Login or Register  to view this content.

When you use the ac object, you have full control over the access application as you would if you had it open (I think). I've only used it once, and it was a while ago.
Best of luck!