Starting another program out of Excel VB??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mac Lingo - 16 Jun 2006 02:54 GMT

How do/can I start another program, like WORD or NOTEPAD, from an EXCEL VB
routine?

I tried doing it with the Marco definition button, but that doesn't collect
things that happen outside EXCEL.

Thanks,
Mac
Berkeley, CA

Reply to this Message

Paul B - 16 Jun 2006 03:52 GMT

Mac, try this for notepad

Sub Run_Notepad()
Run Shell("C:\WINDOWS\NOTEPAD.EXE", 1)
End Sub

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> How do/can I start another program, like WORD or NOTEPAD, from an EXCEL VB
> routine?
[quoted text clipped - 5 lines]
> Mac
> Berkeley, CA

Reply to this Message