Ron de Bruin has sample code to merge a bunch of .csv files into one, then
import it.

Maybe you could modify it to work with your .dat files.

http://www.rondebruin.nl/csv.htm



tuggers wrote:

Could anybody PLEASE help!??

I am trying to import a lot of seperate dat files into a single
worksheet, but every time i try and do this it opens up a seperate
sheet for each file!!

Is there any way i can import all the files, and also continue to
import as new ones are added

ANY help would be greatly appreciated

--
tuggers
------------------------------------------------------------------------
tuggers's Profile: http://www.excelforum.com/member.php...o&userid=29000
View this thread: http://www.excelforum.com/showthread...hreadid=514838

--

Dave Peterson