Run External Programs With VBA

[embirath]

Hi all

I'm wondering if it is a all possible to have a VBA macro call another program (like a Perl scripts, or a Python script) from within VBA?

I have no idea if this is possible. I know that people often write programs which call other programs, but would have no idea where to get started on this.

If it IS possible, can you tell me if it is is extremely complicated?

I have to have a VBA script read some complicated text files, and parse and extract information from them. Perl is so great at this, and I seem to get a headache trying to do any pattern searching and matching with VBA. If it was instead possible to write a Perl script, which is then run by VBA, that would make my life so much easier... :-)

Thank you all in advance.
Emma

[iwrk4dedpr]

You can use the "SHELL" command to run other applications. Whether it would run a perl script I'm not sure. But if you can make a batch file run a perl script then at the very least you can create a batch file which runs the perl script and then using the SHELL command to open the batch file you've accomplished your goal.

[embirath]

Thanks for the pointer! I'll look into this and see if I can get it to work.

Thanks!
Emma

[Dave Hawley]

Start a new thread with a specific question & thread Title of what you want to do (not what you think you need to achieve it) if you need more help.