Indirect Help
 

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


--
xcelion
------------------------------------------------------------------------
xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=401425

Presumably you tried

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

--

HTH

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


"xcelion" wrote in
message ...

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


--
xcelion
------------------------------------------------------------------------
xcelion's Profile:
http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=401425

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

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


--
xcelion
------------------------------------------------------------------------
xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=401425

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

xcelion wrote:

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

--
xcelion
------------------------------------------------------------------------
xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=401425

--

Dave Peterson