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

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

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