Firstly, if you want to call perl scripts from vb, just use system calls and either use return values or text files as a simple way to pass data back and forth.

It may be worth your time to review Activestate's Guide to Using OLE with Perl. This document gives specifics on how to use Win32 OLE within perl to manipulate Excel, among other things. These techniques might allow you to remove the need for a VB application entirely, depending on the amount of user interaction your program requires.

If it is possible for you to remove Visual Basic from the scene altogether, you can use the advice under How do I convert a VBA macro to Perl? to hack together a script that will help (but not perform a 'total' conversion) convert VB code to perl.

In reply to Re: Perl from VB by boo_radley
in thread Perl from VB by ceelly

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.