View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default Store text file in workbook?

In an add-in I'm developing I'd like to pop up a user form that displays a
text file. The text file I want to display is a preformatted table about 20
rows by 40 columns. I have the user form set to a monospaced font.

I thought about putting all the text into a single cell. But I couldn't
easily put the carriage returns where I want them. It likes to do its own
wrapping to fit the cell.

I see I can insert a WordPad object onto a worksheet, but better would be a
NotePad object.

What's the best way to handle this?

My next question will be how to print this text file, but how I end up
storing it has to come first.

Don <donwiss at panix.com.