Thanks for the info.
I used Ken's advice at it was more straightforward (for me), however the
data didn't 'pour in from other books'!

So I now have a spreadsheet with about 500 spreadsheets' full pathnames
in the form ='c:temp\[book4.xls]Sheet1'!$A$1 - this info taken from
other columns, so the formula for the cell is ="="&A4&b4&c4&d4

It seems to look as expected but the actual value cell A1 of book4.xls
is not coming through anywhere..

I'm stuck. Can anybody help me further?
Thanks a lot.
Belinda

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!