How do I trigger an excel macro from an outlook script?

[Knockoutpie]

I have an outlook script that automatically downloads the attachment to my downloads folder from a rule.

After that, I can open excel and run my macro and it will automatically open the file from the downloads folder and run and send an email out.

My question is, how do I complete the in-between? I would like the outlook script to call the excel macro..

The excel macro is Module 30 or Reports Macro

Any help would be much appreciated.

 

[GWteB]

One way could be to rebuild your Excel VBA procedure in a way that it can run inside Outlook VBA.
That way your current script "that automatically downloads the attachment to my downloads folder from a rule" can invoke the other procedure with more ease.

As there's more than one way to skin a cat it depends what's the best approach.