open text file

[birdman]

does anyone know the code to open a text file when a commandbutton on a userform is clicked?? the file extension is

C:\Program Files\Process Files\Help File.txt

so when the commandbutton is clicked, this text file will open.

 

[KenCriss]

I assume you want it to open in Excel? Or maybe shell out to Notepad?

 

[birdman]

notepad

 

[birdman]

does anyone know how to open a text file using notepad when clicking on a commandbutton?

 

[bandit_1981]

call shell ("notepad.exe",7)

that will load up notepad bu tnot sure how to pass the parameter of the file yet

 

[birdman]

while i was waiting for responses i found this thread.

http://www.mrexcel.com/board2/viewtopic.php?t=9605

like the guy in this thread, i have no idea what is going on with the code....but it does work. maybe someone can explain it to me?? thanks for the help

 

[birdman]

on this subject, when i create the help/readme text file to be opened with notepad, how can i make the notepad file uneditable similar to the way most readme files are????

 

[KenCriss]

Birdman - Here is one way or you could use ShellExecute as mentioned in that other post.

      Filestring = "notepad.exe " & myfile
      Response = MsgBox("Data File Created" & Chr$(13) & Chr$(10) & _
            "File = " & myfile & Chr$(13) & Chr$(10) & _
            "Would you like to edit the file now?", vbYesNo, "ABC, Inc.")
      If Response = vbYes Then
             RunIt = Shell(Filestring, 1)
      End If

myfile would = "C:\Program Files\Process Files\Help File.txt" in your case.

OR you could just put the text of what you want to show in a textbox of a userform, so that when they click the button, it will display the info. Put an OK button on the form to enable them to close it. That would make it uneditable but also allow them to see the "readme" info.

Just an idea. Good luck.