Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511

    Unanswered: Run a Windows Application from Excel VBA?

    I would like to open a Windows text editing software product from Excel VBA. In VBA, after I have saved a worksheet as a text file and close the text file, I do some cleanup in the text file with my editor (KEDITW32). The cleanup is automated by using a macro in the editor software.

    Anyone know if it is possible to run another application from VBA, and how do you start up the application?

    Jerry

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Yes you can. Chip Pearson has some introduction/instruction.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    Shades, thanks for the tip. "Shell" is used in one of the examples, and it works--I can run another Windows application from Excel VBA.

    Jerry

    Code:
    Program = "C:\Program Files\KeditW\KEDITW32.exe c:\Temp\Book1.prn (PROFILE CLEANUP"
        TaskID = Shell(Program, 1)

Posting Permissions

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