Fomula to extract from other spreadsheets

[saidb]

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.

 

[Norman Jones]

Hi Saidb,

See Ron de Bruin's sample code at:

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