How to call Excel Add-in function from OLE::32

martinslmn has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I am trying to automate a daily task that involves Excel. I have an add-in that I want to call from OLE::32 with the parameters. I have tried with

Run("add-in_name","arg1","arg2","arg3");
Run("add-in_name",arg1 => "val1", arg2 => "vla2", arg3 => "val3");
[download]

But I could not get it to work. Am I going in the right direction. I searched perlmonks and google but I could not get this done. Please point me in the right direction. Thanks Solomon

Comment on How to call Excel Add-in function from OLE::32 Download Code

Replies are listed 'Best First'.
Re: How to call Excel Add-in function from OLE::32 by marto (Cardinal) on May 14, 2015 at 15:10 UTC
If your version of Excel has the macro recorder, try this.	[reply]