Thank you very much! I appreciate the boost.
Ed

"Dick Kusleika" wrote in message
...
Ed

You can find most of the keywords you need here


http://www.dicks-blog.com/archives/2...h-a-text-file/

like Open, Print, Input. Then check them out in help to get a
description.

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

Ed wrote:
If you want the best of both worlds, take Myrna's advice. Put your
info in a text file, then use VBA's text file keywords to read the
text and insert it in the textbox. It's a little more work up front
coding all of that.

That does sound best, especially since I apparently managed to get
the file open (even though I thought it wasn't working because I
couldn't see it). Now I just have to figure out how to read it into a
string. I think I remember something about that in either a Help
file, KB article, or previous post - probably all three! But of
course, that wasn't the answer I was looking for so I blew right past
it! Well, I can go find it again!

Thanks for the help, Dick.
Ed

"Dick Kusleika" wrote in message
...
Ed wrote:
Dick, it worked great! Thanks.
I had considered the UserForm, but it would seem much easier to
replace a simple text file for updates than to redo the text in a
UserForm text box. Am I missing something?

No, you're right, it is easier that way. I think the trade-off is
how professional it looks (and how much you care about that.) I
think the html and webbrowswer control is a good alternative because
you can replace the html file without changing the code.

If you want the best of both worlds, take Myrna's advice. Put your
info in a text file, then use VBA's text file keywords to read the
text and insert it in the textbox. It's a little more work up front
coding all of that.

Dick