How to use VBA to Open an excel file in notepad

[cornto]

I would like to know that how can i use VBA code to open an excel file on a particular notepad. I had tried out my best in order to get proper solution for the above problem, but unfortunately didn't got any success in it. So, can any body tell me that how to open an excel file on a notepad by using VBA code? Does any body knows about it? Let me know the correct way for doing it.

[Praetor]

According to me you should use the Shell command, in order to Open an excel file in notepad on your system.

Shell "notepad.exe C:\somefolder\myfile.dat"

[Katty]

If all you want to do is open the dat file in Notepad then with the help of shell method you would be able to do it. You can do something like this to make text files and write to them.

Sub test()

Open ThisWorkbook.Path & "\File1.txt" For Append As #1
Print #1, Sheets(1).Range("A1").Value
Close #1

Open ThisWorkbook.Path & "\File2.txt" For Append As #1
Print #1, Sheets(1).Range("A2").Value
Close #1

Open ThisWorkbook.Path & "\File3.txt" For Append As #1
Print #1, Sheets(1).Range("A3").Value
Close #1

End Sub

[kelfro]

You originally said that you wanted to open the file in Notepad from within VBA code. Then you should try out the following code:

RetVal = Shell("C:\WINDOWS\notepad.exe C:\myfile.txt", 1)

Hope so it may help you to open an excel file in notepad using VBA.