indirect question

[cheri]

Sorry, I can't help you but perhaps you can help me. How
do you convert your strings to formula?

-----Original Message-----
I am using the following formula without any luck.

=INDIRECT("'\\dfs01\shares\0535

\LOGS\Energy_Received_Delivered\LogsAug2004\[LogBook" &
TEXT(A1,"yymmdd") & ".xls]Summary'!$E$5")

where A1 is a date. formatted as dd/mm/yyyy Using the formula I get a #REF
error.
In checking my formula concatenating the string the same as in the indirect
expression
=concatenate("'\\dfs01\shares\0535

\LOGS\Energy_Received_Delivered\LogsAug2004\[LogBook" &
TEXT(A1,"yymmdd") & ".xls]Summary'!$E$5")

 

[Don Guillett]

Cheri,
Suggest you start you own thread with a clear question, examples of before
and after.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Sorry, I can't help you but perhaps you can help me. How
do you convert your strings to formula?

-----Original Message-----
I am using the following formula without any luck.

=INDIRECT("'\\dfs01\shares\0535

\LOGS\Energy_Received_Delivered\LogsAug2004\[LogBook" &
TEXT(A1,"yymmdd") & ".xls]Summary'!$E$5")

where A1 is a date. formatted as dd/mm/yyyy Using the formula I get a #REF
error.
In checking my formula concatenating the string the same as in the indirect
expression
=concatenate("'\\dfs01\shares\0535

\LOGS\Energy_Received_Delivered\LogsAug2004\[LogBook" &
TEXT(A1,"yymmdd") & ".xls]Summary'!$E$5")

and then converting that result to a formula gives me a correct response.
What is wrong with my indirect expression?
Thanks!!!!
.