Help on Excel 2000

  • Thread starter Thread starter sacshetty
  • Start date Start date
S

sacshetty

i want to open notepad and make changes in the notepad file..is it
possible for me to open it through excel 2000...i mean can i input a
command or formula in excel sheets so that a notepad file opens
up....or any suggestion will be welcomed.thank u....
 
Hi Sacshetty

This should do the trick. Opens notepad and displays the document.
Change path to suit.

Take care

Marcus


Sub GetNotepad()
RetNote = Shell("C:\WINDOWS\notepad.exe C:\MyXLFiles\Doc1.txt", 1)
'Change this path to appropriate.
End Sub
 
Back
Top