can excel automaticaly open file from specific folder

[sand]

is there any way to copy some cells from excel files of specific folder and
paste it in a single excel file

 

[Gord Dibben]

Have a look at Ron de Bruin's Copy/Paste/Merge VBA code examples.

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


Gord Dibben MS Excel MVP