VBA to open mail attachement, run excel macro, then save as .pdf and email.

[BTSOsupport]

Hi All,

New poster here on the site; I am a IT professional working in SAP BW/BOBJ. I need a little help from my VBA friends however.

I have scheduled a report to be emailed to me daily, I need a VBA script to open the attachement then run an excel macro to format the file correctly. Finally, the file must then be saved as a PDF and emailed to a user.

I do have some VBA scripting done as far as opening the file from outlook, converting to PDF and emailing. My trouble comes on executing the macro; I am unsure how to direct VBA to execute the Macro in this chain.

Thanks in advance for the help!