View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default "Open" or "OpenText"?

Ed

You can use the Shell function to open it in a certain program, e.g.
Notepad.

?shell("notepad.exe 'C:\Testfile.txt'")

The best thing, IMO, is too make another userform with a scrollable textbox
that has all this info. Then your button just shows this useform.

If you want to get fancy, you could do it in html and use the webbrowser
control on a userform as described here
http://www.dicks-blog.com/archives/2...ng-help-files/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com


Ed wrote:
The workbook I'm developing opens with a UserForm. I'd like to put an
"About" button on the form that opens a text file that describes its
functions a bit. Does Excel have a provision to open just a "read
me" type file? "Open" looked it was reserved for Excel files, and
"OpenText" for files to parse and import. Is one of these the right
one to use, or is there a better way?

Ed