ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Starting another program out of Excel VB?? (https://www.excelbanter.com/excel-worksheet-functions/94341-starting-another-program-out-excel-vbulletin.html)

Mac Lingo

Starting another program out of Excel VB??
 
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



Paul B

Starting another program out of Excel VB??
 
Mac, try this for notepad

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


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

"Mac Lingo" wrote in message
m...
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






All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com