Hi and welcome to Ozgrid,
There are a number of ways to merge 2 files - but could use a bit more info to determine which would work best for your applicaiton.
Do both files have the same filename - just stored in different directories?
Do both files have EXACTLY the same format - titles, fields, formats, worksheets, etc the same and in the same place?
What type of data is in the 2 files - - is it 2 lists (like names/addresses) that you want to combine into 1 master list; or is it numbers that you want to add together and put to totals into the merged sheet?
The file attachment feature is not working right now - so best you can to is explain all the details in a post.
Thanks for the help ralph but i found a utility docdiff or something on http://www.softinterface.com and did it semi-manually
Haven't had time to return to the forum the last couple of days.