If you use Winzip use my mail add-in or the code examples from my site
http://www.rondebruin.nl/mail/add-in.htm
Use version 3

Or see
http://www.rondebruin.nl/zip.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mattgoof2005" wrote in message ...
If it's too large to email, just use WinRar to create smaller,
self-extracting .rars
This way you don't have to worry about links.
"RBW" wrote:

I have created a workbook (A) that pulls data from workbooks (B) and (C). If
I combine A with B or C or both, the resulting workbook becomes too large to
email. If I email the files separately to other users (who are not
especially Excel literate), the links in A fail to update, since they are
pointing to files on my computer, not theirs. I'm very reluctant to ask
users to edit the links in A to point to the correct files; I've got little
confidence that will be successful.

Is there a way to specific relative, not absolute file path names, so that
as long as B and C are in the same directory as A, a remote user can download
all three files into one directory and have the links in A work correctly?

Many thanks in advance for your help.