Probably. Take a look at Ron's site:
http://www.rondebruin.nl/tips.htm
specifically, his article on "Merging Data from Multiple Workbooks"
http://msdn.microsoft.com/en-us/library/cc837974.aspx
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"micjil" wrote:
I have multiple Excel workbooks and need to extract the data from certain
cells in order to sum the cells into a summary workbook. Can this be done?