This is a difficult one.....I have posted this before and what you se
below is as far as it has gotten. Please help!

I am writing a formula in cell "B1" in "December 2007 REVISED B
DAN.xlsm" that will reference cell "X1" in a workbook that has not bee
created yet.
The way I will tell the formula what the name of the workbook will b
is by referencing cell "A1" and adding the extension ".xlsx" to it.

Example:
"December 2007 REVISED BY DAN.xlsm"
_A________|B__________________________________________________________________________________________________________________________|C
1_DANTEST_|__=INDIRECT("C:\Documents an
Settings\DBryant\desktop\B.D.I. SPREADSHEET PROJECT\CONTINUATIO
SHEETS\'["&A1&".xlsx]Sheet1'!X1")___________|__
2_________|_________________________________________________________________________________________________________________________|_

It doesn't work.
I receive a reference error. I would expect this to happen if th
contents of "A1".xlsx did not yet exist, but infact it does.
The value of "A1" in my workbook containing the formula is "DANTEST"
The workbook C:\Documents and Settings\DBryant\desktop\B.D.I
SPREADSHEET PROJECT\CONTINUATION SHEETS\DANTEST.xlsx
does currently exist, and cell "X1" has the contents "HOORAY!". (
little celebration if I can get the formula to work

What next?
-Any help is appreciate

--
DINGO0Z