Need help automating a MS Access Report --> MS Excel macro; way to make Access run Excel macro on a spreadsheet?

I have been tasked with creating a report in MS Access and creating an identical report in MS Excel.

I had no trouble creating/formatting the MS Access report but "exporting" it to Excel proved problematic.

I learned that it's not possible to do a quick-and-dirty export so I decided I would use an Excel macro to take the horribly out-of-whack spreadsheet that resulted from the MS Access report and output it in a more presentable format.

So, at present these are the steps in this process:

1. Run report (rpt_loans) in MS Access
2. Tools --> Office Links --> Analyze it with Microsoft Excel
3. Excel file opens (rpt_loans.xls)
4. I need to open the Excel file (called "loansrpt_macro.xls") in which I wrote the formatting Macro
5. alt+tab from loansrpt_macro.xls to rpt_loans.xls
6. hit alt+F8, make sure "All Open Workbooks" option is chosen from the "Macros in:" drop down menu
7. click "Run"

As you can see this is a bit of an involved process. It's not at all difficult for me or any minimally computer savvy person to do but because many different people in my company need to access this report in both Access and Excel format, I'm looking for a way to make the process simpler and more automated.

Any suggestions as to how I can have this done in a quicker and easier way? *Ideally*, I would like to create a button in Access that actually does steps 1 through 7 above, it runs the Access report, exports it to Excel and runs the loansrpt_macro.xls Macro on the exported file, resulting in a clean and prepared Excel spreadsheet ready to be used.

Anybody have any idea if this is possible and, if so, how I can do it?

Thanks.