W
WayneF
Dear all,
After some advis here,
I have several workbooks all with different names but in the same
directory
I.E.
Excel1.xls
Excel2.xls
Excel3.xls
Excel4.xls
In each of the above I want to get out the value for say A2.
And put it in a totals.xls in the same directory.
I started to do it and I got this as my value ..
='[Excel1.xls]Expense Report'!$R$20 <-------- This returned the
correct value.
When i opened the document again it asked if i wanted to "update" the
workboog ... whick i did want to have the updated info, the problem now is
that it changed the cell value to this ...
='C:\Documents and Settings\Wayne\Desktop\Wayne''s expenses\Weeks
2006\[Excel1.xls]Expense Report'!$R$20
Which is really not what i want because i will not be able to share this
workbook !!
Any ideas or better ways to do this ?
Cheers,
Wayne
After some advis here,
I have several workbooks all with different names but in the same
directory
I.E.
Excel1.xls
Excel2.xls
Excel3.xls
Excel4.xls
In each of the above I want to get out the value for say A2.
And put it in a totals.xls in the same directory.
I started to do it and I got this as my value ..
='[Excel1.xls]Expense Report'!$R$20 <-------- This returned the
correct value.
When i opened the document again it asked if i wanted to "update" the
workboog ... whick i did want to have the updated info, the problem now is
that it changed the cell value to this ...
='C:\Documents and Settings\Wayne\Desktop\Wayne''s expenses\Weeks
2006\[Excel1.xls]Expense Report'!$R$20
Which is really not what i want because i will not be able to share this
workbook !!
Any ideas or better ways to do this ?
Cheers,
Wayne