I would like to have a static file location that does not change if
email the workbook to somebody. Is this possible?

Here is an example of what I would like to do.

=IF(L8=TRUE,'C:\Documents\Football\Week 3\[Pool Score Sheet.xls]Scorin
Tab'!$B3,IF('C:\Documents\Football\Week 3\[Pool Score Sheet.xls]Scorin
Tab'!$B3=0,1,0))

I would like the C: Documents ... to never change. I will be emailin
this sheet so I want to formula to refer to my computer and not th
recipent. Please help

--
TwEaKFrEa
-----------------------------------------------------------------------
TwEaKFrEaK's Profile: http://www.excelforum.com/member.php...fo&userid=1300
View this thread: http://www.excelforum.com/showthread.php?threadid=26246

Hi
and you're on a network so the recipient could access this file from
his computer?. if yes then why email at all?

--
Regards
Frank Kabel
Frankfurt, Germany

"TwEaKFrEaK" <(E-Mail Removed)> schrieb im
Newsbeitrag news:(E-Mail Removed)...
>
> I would like to have a static file location that does not change if I
> email the workbook to somebody. Is this possible?
>
> Here is an example of what I would like to do.
>
> =IF(L8=TRUE,'C:\Documents\Football\Week 3\[Pool Score
Sheet.xls]Scoring
> Tab'!$B3,IF('C:\Documents\Football\Week 3\[Pool Score
Sheet.xls]Scoring
> Tab'!$B3=0,1,0))
>
> I would like the C: Documents ... to never change. I will be
emailing
> this sheet so I want to formula to refer to my computer and not the
> recipent. Please help.
>
>
> --
> TwEaKFrEaK
> ---------------------------------------------------------------------
---
> TwEaKFrEaK's Profile:
http://www.excelforum.com/member.php...o&userid=13002
> View this thread:
http://www.excelforum.com/showthread...hreadid=262466
>