A couple of things -
The file type will need to be changed to CSV.
(I am not sure how to do this)
The code itself can go anywhere you want.
You can either build a special workbook to hold it. In which case
you will need to open that workbook to use it.
Or you could put it in your Personal.xls (this opens automatically
everytime you open Excel.
--
steveB
Remove "AYN" from email to respond
"jackm1" wrote in
message ...
the files are all in .csv format.
--
jackm1
------------------------------------------------------------------------
jackm1's Profile:
http://www.excelforum.com/member.php...o&userid=25399
View this thread: http://www.excelforum.com/showthread...hreadid=388721