You could do it with ADO, but why bother, open it and close it, it will be
quick, and by setting ScreenUpdating to false, you can hide it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"gti_jobert" wrote
in message ...

Hi all,

I want to know if its possible to select all data from a workbook on
Sheet1 and paste it into my current open workbook without opening it.

If its possible, how would I go about doing this?

All help welcome.....cheers.


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=518700