Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 4 of 4

Thread: Run External Programs With VBA

  1. #1
    Join Date
    24th October 2007

    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.

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    22nd January 2004
    Colorado Springs

    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. #3
    Join Date
    24th October 2007

    Re: Vba Running External Programs??

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


    Excel Video Tutorials / Excel Dashboards Reports

  4. #4
    Join Date
    24th January 2003

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Launch Dts And Vb Programs In Access
    By austenr in forum Excel and/or Access Help
    Replies: 2
    Last Post: October 4th, 2006, 05:03
  2. closing exe programs through vba
    By kathy32181 in forum Excel General
    Replies: 4
    Last Post: August 31st, 2004, 23:37
  3. Network : programs and softwares
    By opeyemi1 in forum Excel General
    Replies: 1
    Last Post: April 6th, 2004, 06:08
  4. VBA: Fun Programs
    By torpedo13 in forum Test Area
    Replies: 11
    Last Post: October 27th, 2003, 18:01


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts