VBA to Open an excel file in notepad

Solved/Closed
PM - Oct 8, 2009 at 02:47 AM
 Blocked Profile - Oct 8, 2009 at 04:10 AM
Hello,

Can someone tell me the vba code to open an .xls or .csv file in notepad?

thanks

PM

1 reply

Blocked Profile
Oct 8, 2009 at 04:10 AM
Dear Sir,

Below is an example which will facilitate your task:

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

Thanks in advance.
10