Ok, so what exactly do you need?

My guess is that you have the filename in a cell and want to reference that
cell in the formula? Need details!

Side note: man, I hate long filenames and paths! <bg

Biff

"Jonrey" wrote in message
...
Biff,
Your assumption was correct. We send out a survey and are trying to
automatically compile the results. All returned surveys are saved to the
same
directory with different names. The formulas (with different external cell
references) concatenate like this:
=IF($B7="","",'I:\NKP\Surveys\NKP Survey Feed Back\[NKP Survey NPPA
61-0602-02852.xls]Tabulation'!$W$4)

Ken,
I have tried to do it with INDIRECT as you suggested, with the new survey
worksheet open but haven't been able to make it work.

Any assistance would be greatly appreciated.

Jonrey

"Ken Wright" wrote:

You would need to use INDIRECT() to convert your text expression into a
formula, but it won't work if you are referencing a closed workbook.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"Jonrey" wrote in message
...
I am compiling data from several different, variable, worksheets. I am
using
concatenate to add the name of each worksheet into a formula to pull
the
appropriate data. However, it is returning the text of the formula
instead
of
the results of the formula. How can I make it calculate the result
instead
of
simply displaying the formula text?