Indirect Help

[xcelion]

HI All,

I need to give thi
'*\\10.10.1.80\Miscellaneous\Adarsh\Calculation\[OAR Coupon - Timeshee
- Satheesh.xls]Timesheet'!D5* string as argument to Indirect function
I tired several combination of single and double quotes but iam no
able to get the correct result using formula .Can any one please help

Thanks in advance
Xcelio

 

[Bob Phillips]

Presumably you tried

=INDIRECT("'*\\10.10.1.80\Miscellaneous\Adarsh\Calculation\[OAR Coupon -
Timesheet
- Satheesh.xls]Timesheet'!D5")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[xcelion]

yes i tired the same but i don't understabd what is * in your formula

=INDIRECT("'*\\10.10.1.80\Miscellaneous\Adarsh\Calculation\[OAR Coupon
-
Timesheet
- Satheesh.xls]Timesheet'!D5")

 

[Dave Peterson]

=indirect() will return an error if it refers to a closed workbook.

HI All,

I need to give this
'*\\10.10.1.80\Miscellaneous\Adarsh\Calculation\[OAR Coupon - Timesheet
- Satheesh.xls]Timesheet'!D5* string as argument to Indirect function .
I tired several combination of single and double quotes but iam not
able to get the correct result using formula .Can any one please help

Thanks in advance
Xcelion