in reply to Getting VBA code to run a Perl script in a network drive

This isn't a Perl problem. If you can work out how to call any executable in the way you want to call your Perl script, then you only have to substitute the appropriate command line. Something like: 

\\machineWithPerl\path\To\perl.exe \\MachineWithYourScript\path\to\You
+rScript.pl

[download]

But that leaves how to invoke an executable, via VBA, from within Excel, to run on a remote machine, having discovered the appropriate IP.

All of which is nothing to do with Perl, and this is almost certainly not the best place to get that expertise.

Examine what is said, not who speaks.        The end of an era!
"But you should never overestimate the ingenuity of the sceptics to come up with a counter-argument." -Myles Allen
"Think for yourself!" - Abigail        "Time is a poor substitute for thought"--theorbtwo         "Efficiency is intelligent laziness." -David Dunham
"Memory, processor, disk in that order on the hardware side. Algorithm, algorithm, algorithm on the code side." - tachyon

In Section Seekers of Perl Wisdom