G Guest Mar 22, 2005 #1 I'd like to create a macro to launch notepad while in Excel. The macro should then return to the opened spreadsheet in Excel.
I'd like to create a macro to launch notepad while in Excel. The macro should then return to the opened spreadsheet in Excel.
P papou Mar 22, 2005 #2 Hi Shell "NOTEPAD.EXE" AppActivate "Microsoft Excel" (tested on Win Xp Pro + Excel 2003) HTH Cordially Pascal
Hi Shell "NOTEPAD.EXE" AppActivate "Microsoft Excel" (tested on Win Xp Pro + Excel 2003) HTH Cordially Pascal
J Jason Morin Mar 22, 2005 #3 Sub OpenNotepad() Dim RetVal As Variant RetVal = Shell("C:\Windows\Notepad.exe", 4) MsgBox "Notepad is open." End Sub
Sub OpenNotepad() Dim RetVal As Variant RetVal = Shell("C:\Windows\Notepad.exe", 4) MsgBox "Notepad is open." End Sub
G Gareth Roberts Mar 22, 2005 #4 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
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