Run a Windows Application from Excel VBA?

JerryDal · #1 (**permalink**) 03-09-06, 14:35

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

shades · #2 (**permalink**) 03-09-06, 17:09

Howdy. Yes you can. Chip Pearson has some introduction/instruction.

JerryDal · #3 (**permalink**) 03-09-06, 17:21

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)

Internet Services

Web Development

Digital Marketing

Consumer Tech