saving formula result automatically............

  • Thread starter Thread starter heartbreakkid
  • Start date Start date
H

heartbreakkid

I have info in a workbook which i want to referenced in anothe
workbook,
I used INDIRECT("'[" & A1 & ".xls]report'!a1");with A1 being the nam
of the workbook ,to get the the info...... the problem is this onl
works when the workbook is open. when u close the the other workboo
the result goes back to #REF.
is there someway i can save that result automatically in a differen
cell or something without having to deal with that 'hated' #REF whe
the other workbook is closed?

i hope ya'll understand what i wrote!


Thanx in advanc
 
is there anybody who can help me out.... or give me another
alternative??.... thanx
 
Harlan Grove wrote a userdefined function that may help you:

http://google.com/[email protected]

heartbreakkid < said:
I have info in a workbook which i want to referenced in another
workbook,
I used INDIRECT("'[" & A1 & ".xls]report'!a1");with A1 being the name
of the workbook ,to get the the info...... the problem is this only
works when the workbook is open. when u close the the other workbook
the result goes back to #REF.
is there someway i can save that result automatically in a different
cell or something without having to deal with that 'hated' #REF when
the other workbook is closed?

i hope ya'll understand what i wrote!

Thanx in advance
Click to expand...
 
Back
Top