View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Novice Lee Novice Lee is offline
external usenet poster
 
Posts: 36
Default Opening a txt file

I guess you can call it plain text ( I can open it in Notepad). When I select
the file the text import wizard pops up, I hit next twice then finish. and
there the file is. Each piece of data in it's own cell.

I was also thinking about get rid of < in alot of the cells, but that for
another day

Thanks


"Rick Rothstein (MVP - VB)" wrote:

What kind of text file are we talking about... plain text, CSV file,
something else?

How or where did you want to open it... in a TextBox, MessageBox, single
cell, multiple cells, etc.?

Rick


"Novice Lee" wrote in message
...
Is there a way to create a button that open a text file with the same name
all the time and bypass the additional dialog boxes

Thanks