Thanks for the interest guys

I have been trying to open them via the open option in the file menu o
the menu bar. This seems to be the only way to import dat. files??
Then when i had selected them all and gone through the import tex
screens, each file is imported as a seperate worksheet.

If there is a better way, id be happy to try it.
Is anybody able to supply me with the required vba code to import th
entire contents of the folder into a single worksheet?

I would greatly appreciate it

--
tugger
-----------------------------------------------------------------------
tuggers's Profile: http://www.excelforum.com/member.php...fo&userid=2900
View this thread: http://www.excelforum.com/showthread.php?threadid=51483