VBA to Open an excel file in notepad [Solved/Closed]

PM - Oct 8, 2009 at 02:47 AM - Latest reply: iveal 2801 Posts Thursday May 14, 2009Registration date September 28, 2010 Last seen
- 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
See more 

1 reply

Best answer
iveal 2801 Posts Thursday May 14, 2009Registration date September 28, 2010 Last seen - Oct 8, 2009 at 04:10 AM
10
Thank you
Dear Sir,

Below is an example which will facilitate your task:

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

Thanks in advance.

Thank you, iveal 10

Something to say? Add comment

CCM has helped 1763 users this month