It might be possible using ADO (DAO??), but it's beyond me.

Why not just open the workbook, extract the data, and close the workbook.

With screenupdating=false, it may not even be noticeable by the user.

maxzsim wrote:

Hi,

I want to copy data from an excel file to another excel file w/o having
to open the source excel file using codings. Is this possible ?

tks & rdgs

--

Dave Peterson