On Sun, 16 Mar 2008 17:18:03 -0700 (PDT), Georgie
wrote:

Hi Dave

I need to take a value from an Excel 03 spreadsheet and copy it into
an Excel 07 spreadsheet. I have been able to do this, however I need
to be able to update the Excel 07 spreadsheet each week and the figure
is linked back to the Excel 03 spreadsheet, so it says I am unable to
update the link due to the source.

FYI, I have an Excel '07 workbook that seems to be able to obtain data from an
Excel '03 closed workbook without any problem.

Actually, I have several set up like that.

So perhaps your problem is elsewhere.

The Excel 07 workbooks are *.xlsm and the 03 is, of course an *.xls

--ron