On Wed, 25 Jan 2006 19:20:02 -0800, "cjmillerFL"
wrote:

Thanks Ron,

That worked very well. As a followup, is there anyway to have the macro
prompt me for the file to open?

--
C.J. Miller

Here's something simple I came across, but I don't have enough experience in
this area to know the potential pitfalls:


---------------------
Dim fn As Variant

fn = Application.GetOpenFilename("Text Files (*.txt), *.txt")
If fn = False Then Exit Sub

Workbooks.OpenText FileName:=fn _ ...

(the rest of your data/text to columns process)
-------------------------
--ron