Welcome to the Monastery.

If you understand the "VBA Code" and you understand Perl - transcoding is a fairly simple job.

If you understand one but not the other, the way to complete the job is to learn the one you don't know
...and if you understand neither, then you probably need to hire someone who understands both. Please see How do I post a question effectively?.

Despite the tacit offer from mickeyn above, generally, you'll get better answers if you show what you've tried and tell us *HOW* that fails.