Fomula to extract from other spreadsheets

Can anyone assist on how I am able to extract selected cells from other spreadsheets into a new workbook. I have like 20 different workbooks and want to create a macro to extract certain cells from the 20 workbooks into a new one.

Hi Saidb,

See Ron de Bruin's sample code at:

http://www.rondebruin.nl/ado.htm


---
Regards,
Norman



"saidb" <saidb.289blz_1148382010.8773@excelforum-nospam.com> wrote in
message news:saidb.289blz_1148382010.8773@excelforum-nospam.com...
>
> Can anyone assist on how I am able to extract selected cells from other
> spreadsheets into a new workbook. I have like 20 different workbooks
> and want to create a macro to extract certain cells from the 20
> workbooks into a new one.
>
>
> --
> saidb
> ------------------------------------------------------------------------
> saidb's Profile:
> http://www.excelforum.com/member.php...o&userid=34664
> View this thread: http://www.excelforum.com/showthread...hreadid=544644
>