It is because of the punctuaction. Try this version of your formula:
="'C:\Reports\Trial Balances\[""Trial
Balance"""&TEXT(A13,"yyyy-m-d")&".xls]100'!$A$9"

Miguel.

"Capp" wrote:


This is what I have put in.

='C:\Reports\Trial Balances\["Trial Balance
"&text(A13,"yyyy-m-d")&.xls]100'!$A$9

I get #REF!

Is there something I am overlooking?

"Miguel Zapico" wrote:

You can try with HYPERLINK and TEXT, something like this:
=HYPERLINK("file://C:\Reports\Trial Balances\[Trial Balance " &
TEXT(A3,"yyyy-m-dd") & ".xls]")
You can add a descriptive name if you like it better, as the second
parameter of HYPERLINK.

Hope this helps,
Miguel.

"Capp" wrote:

I am trying to streamline a database like spreadsheet.
In my worksheet each cell in successive rows in a column, references a
different file depending on date in another column. All the linked paths and
file names are the same with the exception of the date in the name. Is there
a way to change the filename using the contents of the date cells on my
worksheet.

Dates: A2:A100
Linked Cells: B2:B100 (I would like each link to reference the date in
adjscent cell)

i.e. If the date in Cell A3 shows April 30, 2006, this date will be in the
path as shown below.

'C:\Reports\Trial Balances\[Trial Balance "yyyy-m-dd".xls].

Can this be done?

Any help is greatly appreciated.

Cappster