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.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|