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

- - Latest reply: iveal
Posts
2800
Registration date
Thursday May 14, 2009
Last seen
September 28, 2010
- 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
Posts
2800
Registration date
Thursday May 14, 2009
Last seen
September 28, 2010
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

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2574 users this month