You are most likely going to need to write some sort of parsing engin
to deal with the unique nature of the imported file. I have done thi
in several different capacities, but the methods I would follow to wor
with your case would be to do the following:

1) write a loop that will input line by line from the original file
stripping out bogus characters (such as all the ====+====+===)
2) replace the ||||| with spaces
3) look for certain keys that do not change - "Days Taken" or somethin
similar as your start point

--
crispb
-----------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...fo&userid=1088
View this thread: http://www.excelforum.com/showthread.php?threadid=27361