Retrieve data from unopened workbook
 

Hello Programmers!

VBA

I was wondering about the line of code (or a code) that can get
information from a cell, from a workbook, without opening that
workbook?

Also is it possible to copy an entire worksheet, from another workbook,
without opening that workbook?

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=553286

Retrieve data from unopened workbook
 

Hi EMoe

See this two pages for a possible solution
http://www.rondebruin.nl/ado.htm
And
http://www.rondebruin.nl/copy7.htm

If you want to copy a sheet you must open the files
See
http://www.rondebruin.nl/copy3.htm

--
Regards Ron De Bruin
http://www.rondebruin.nl



"EMoe" wrote in message
...

Hello Programmers!

VBA

I was wondering about the line of code (or a code) that can get
information from a cell, from a workbook, without opening that
workbook?

Also is it possible to copy an entire worksheet, from another workbook,
without opening that workbook?

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=553286

Retrieve data from unopened workbook
 

Thanks Ron!

This is helpful. I knew that I saw some info out there on this. I just
couldn't remember where.

Thanks Again!

Regards,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=553286