Hi,

I'm trying to create a global workbook that creates a summary from various other workbooks. The aim of this is to produce a report from team members WIP lists that can be viewed at weeking team meetings. On opening the global workbook, it will initiate a macro to gather data located in a specific range from the other workbooks and copy it into the global one.

The problem I am having is that the code I'm writing in the global workbook doesn't recognise the other workbooks. I've managed to open those workbooks but am unsure as to how to either run the marcos for those workbooks to gather the data, or just to navigate round the other workbooks from the global one.

Does anyone have any example code that is similar to this that I can view?

Cheers
Chewy