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!