I have several a directory of text files that contain the same data but
for different weeks.

E.G.

JANHOURS.txt
FEBHOURS.txt
MARHOURS.txt
APRHOURS.txt
TOTALHOURS.txt

I want to combine all the files ending with hours into totalhours.txt
so it can be loaded into a pivot table. However I need this to be
automatic. I know it can be done using a batch file, but I can't
remeber the batch code to do this. Can anyone help?

Thanks


--
nickysquawkes
------------------------------------------------------------------------
nickysquawkes's Profile: http://www.excelforum.com/member.php...o&userid=30630
View this thread: http://www.excelforum.com/showthread...hreadid=502858