I have 2 workbooks, lets call them a.xls and b.xls.
a.xls gets updated once a day, and b.xls has a display of the cumulative info from a.xls. How do I get the info from a.xls into b.xls?
Ive tried the following formula, but I just get told there is an error.
=C:\[a.xls]sheet1!$B$4+[a.xls]sheet1!$B$5
There isnt an ' at either end, and the files are in the correct places. I get warned about the error on pressing enter. Ive tried the following, thinking that maybe it was a sheet name issue, but no joy.
=C:\[a.xls]'sheet1'!$B$4+[a.xls]'sheet1'!$B$5
Im using Excel 2000, on WinXP.
ALL help will be appreciated.
a.xls gets updated once a day, and b.xls has a display of the cumulative info from a.xls. How do I get the info from a.xls into b.xls?
Ive tried the following formula, but I just get told there is an error.
=C:\[a.xls]sheet1!$B$4+[a.xls]sheet1!$B$5
There isnt an ' at either end, and the files are in the correct places. I get warned about the error on pressing enter. Ive tried the following, thinking that maybe it was a sheet name issue, but no joy.
=C:\[a.xls]'sheet1'!$B$4+[a.xls]'sheet1'!$B$5
Im using Excel 2000, on WinXP.
ALL help will be appreciated.