William,
I ran your macro at the end of my first text file import, ran th
import again, and it blew up because it was looking for pivot table
instead of 2, so it didn't appear to work.

Any other suggestions

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