View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_3_] Gary Keramidas[_3_] is offline
external usenet poster
 
Posts: 72
Default Startup Notepad from Excel???

try this

shell("C:\windows\notepad.exe")

--


Gary Keramidas
Excel 2003


"Robert Crandal" wrote in message
...
I am interested in using VBA to transfer some of my
spreadsheet data as regular text into another application
such as Notepad (or even MS-Word). So, my two
questions a How can I use VBA to start up Notepad?
How can I tell Excel to write data into Notepad??

Or, do you guys think it would be easier to use VBA
to transfer text data from Excel into Word??

thank you!