No announcement yet.

Run External Programs With VBA

This topic is closed.
  • Filter
  • Time
  • Show
Clear All
new posts

  • Run External Programs With VBA

    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.

  • #2
    Re: Vba Running External Programs??

    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.

    My Favorite New Thing:
    Dynamic Named Ranges

    The alternative for
    "Press Any Key To Continue."

    and we all have one we'd like to use it on

    1. Cross Posting Etiquette
    2. Are You Here To Learn: What Have You Tried?
    3. Your Best Resource to begin learning VBA: RECORD A MACRO . . . Then Study It!


    • #3
      Re: Vba Running External Programs??

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



      • #4

        Re: Vba Running External Programs??

        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.