1st: At my company there is no network...that's right. No shared drives
(and this isn't a small company).

So...

How do I link workbooks together with a relative path so I can send them to
someone else and still have them work.

I.E. if I want a cell in Workbook 2 to be the same as a cell in Workbook 1 I
simply enter

=

and click on the cell in Workbook 1.

What Excel translates that to is ='C:\Documents and Settings\Tallen\My
Documents\Reports\Commercial Discharges\[WorkbookName & Cell Range]')

I need to be able to EMAIL both of these documents to someone and have them
function. I've tried deleting all of the extra pathname garbage from the
formula so hopefully the workbook would just look in the same directory it is
in for the other file...but that doesn't work, Excel just puts the path
information right back in after I delete it.

So is there a way to get Excel to look for a file RELATIVE to its current
location (like the same directory) rather than at a full FIXED PATH?