Indirect Help

X

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
 
B

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)
 
X

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")
 
D

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
Click to expand...
 
Top