The rest of the import seems to be working fine i am excited about that. However there have been a few time where I will get, i think its a runtime error saying "the database has been placed in a locked state" (or something like that).

There is one small thing i need to do. Originally there is a summary sheet as the 1st sheet in the workbook. Since that sheet isn't needed for analysis I have code that opens each workbook and deletes that sheet before the merge is done and saves the workbook without the summary sheet. That part works fine. But if i try to merge two workbooks and the summary sheet is already deleted the code breaks because it is looking for a sheet that doesnt exist. So I am thinking this is just a simple if...then statement. Something like:

[VBA]If not object.worksheets("Summary") is nothing then
object.worksheets("Summary").delete
else
msgbox "Summary sheet deleted"
end if[/VBA]

i tried to implement this and i get 'subscript out of range'. so that makes me think its something with one of the elements in the array. Could someone confirm this and give a little more detail on the logic here?

Thanks again for all the help.