Help on Excel 2000

[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....

 

[marcus]

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