I posted an example of how to incorporate
some Perl into a VBA function in Excel.
This is probably similar in VB/VB Script.
As to
the other way round: Inline::VB anyone?
(Actually, I think a monk wrote a VB to Perl translator,
but I don't have time to super search for it just now).