open text file

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

hi

how can I open a text file with VBA to visual it

I use: call shell ("Name of the")

but it's not working

any ideas

thx
 
losmac said:
myFile = "C:\someTextFile.txt"
retVal = Shell("C:\Windows\Notepad.exe " & myFile)
Click to expand...

Or, to avoid having to know where Notepad is installed, or in case the
user has some other application to edit text files:

Application.FollowHyperlink "C:\someTextFile.txt"
 
Back
Top