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 response

Answer 1 / 1

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.