Here’s a conundrum for you!

Here’s a conundrum for you!

I manage a couple of .DBF files imported from two other companies. These files are produced by two identical copies of the same program and thus output a file with the same name.
Previously this was not a problem as the files could be opened independently, and renamed so that both copies could be open at the same time.
I am wondering if anyone out there has managed to programmatically open a file within Excel save the contents to one worksheet. Then had excel open the second file and save the contents to another worksheet in the newly opened workbook without having any annoying messages to the fact that the file already exists.

Thanks for taking the time to read this, all comments would be gratefully received
Quackers