I'd like to create a macro to launch notepad while in Excel. The macro
should then return to the opened spreadsheet in Excel.

Hi
Shell "NOTEPAD.EXE"
AppActivate "Microsoft Excel"
(tested on Win Xp Pro + Excel 2003)
HTH
Cordially
Pascal

"cheryljohnson" a écrit dans le
message de ...
I'd like to create a macro to launch notepad while in Excel. The macro
should then return to the opened spreadsheet in Excel.

Sub OpenNotepad()
Dim RetVal As Variant
RetVal = Shell("C:\Windows\Notepad.exe", 4)
MsgBox "Notepad is open."
End Sub

--
HTH
Jason
Atlanta, GA

-----Original Message-----
I'd like to create a macro to launch notepad while in
Excel. The macro
should then return to the opened spreadsheet in Excel.
.

Just to add to this, if you have a specific file in mind, you can add it to
the command line e.g.

shell "notepad c:\myfile.txt"

Gareth

"papou" wrote in message
...
Hi
Shell "NOTEPAD.EXE"
AppActivate "Microsoft Excel"
(tested on Win Xp Pro + Excel 2003)
HTH
Cordially
Pascal

"cheryljohnson" a écrit dans le
message de ...
I'd like to create a macro to launch notepad while in Excel. The macro
should then return to the opened spreadsheet in Excel.