Excel to Excel Data transfer without opening any of the files(source or target)

[Rajan_Verma]

I am not a "database person" myself, so I do not know the answer to this question... Do either, or both, of the text sections I highlighted in red in any way restrict the functionality of your subroutine to a specific version of Excel or, perhaps, a specific version of some database engine?

Hi Rick,

this will work on 2007 and 2010

Rajan