Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Run External Programs With VBA

  1. #1
    Join Date
    24th October 2007
    Posts
    5

    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.
    Emma

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    22nd January 2004
    Location
    Colorado Springs
    Posts
    3,842

    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.
    Regards,
    Barry

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

    Re: Vba Running External Programs??

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

    Thanks!
    Emma

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,705

    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. Programs: Microsoft(r) Excel
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: July 9th, 2008, 18:17
  2. 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
  3. closing exe programs through vba
    By kathy32181 in forum EXCEL HELP
    Replies: 4
    Last Post: August 31st, 2004, 23:37
  4. Network : programs and softwares
    By opeyemi1 in forum EXCEL HELP
    Replies: 1
    Last Post: April 6th, 2004, 06:08
  5. VBA: Fun Programs
    By torpedo13 in forum Test Area
    Replies: 11
    Last Post: October 27th, 2003, 17:01

Bookmarks

Posting Permissions

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