Thanks Guys,
I am trying stop too much user intervention and allow them to just select
the file they want to import.

all the best,

Steve Wilson.

"BrianB " wrote in message
...
Have you tried renaming the file with a .txt suffix so you get the
wizard when importing ? You can then set the column formats
individually. You can record macro code and change to .csv in that.


---
Message posted from http://www.ExcelForum.com/