Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mac Lingo
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
I cant open files unless I open the Excel program first ElaineAng Excel Discussion (Misc queries) 3 February 16th 06 02:54 PM
Excel Program Error - Excel.exe Generated Errors Message Denise Lane Setting up and Configuration of Excel 4 March 18th 05 10:09 PM
Starting MS Excel with a worksheet other than SHEET 1 IGNACIO Excel Worksheet Functions 2 February 18th 05 06:29 PM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"