How to Open a notepad from VBA....Urgent

[winpoorni]

Hi all, Im Working with Excel Macro facility. i need to write some text in notepad.how can i open a notepad from vba.. (in VBA we can add commondialog control box and open a notepad.. i need some other way) Help ME Thanks n Regards, Ramya.R -- modified at 4:04 Friday 24th February, 2006

[Divya Rathi]

/*The following code Opens notepad when a key is pressed . When the up key is pressed , notepad will open */ Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) Dim keyPress As Double If KeyCode = vbKeyUp Then keyPress = Shell("notepad.exe", vbNormalFocus) End If End Sub Divya Rathi

[winpoorni]

Thanks Divya, I use VBA in Macro level..still no forms are used... by using shell("notepad.exe") command i open the Note pad.. I need to append the data to that opened Notepad and save that file... Help me Please.. Thanks in advance.... Thanks n Regards, Ramya.R -- modified at 4:10 Friday 24th February, 2006

[sathish s]

this shd be useful http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office09072000.asp

[Divya Rathi]

why do u explictly need to create notepad ? coz if u want to save data from some text box then there are many file handling operations are there. Divya Rathi