Hiya guys and gals

I have a problem.

I have a work sheet that references 10 external workbooks.

What i need to do is for my worksheet to look for the external workbook
in the same folder as the main workbook is stored in instead of having
the full C:\Documents and Settings\James\Excel\

As i have to create multiple documents and email them to others they
may chose to save them in alternate locations. If they do this when the
workbooks are opened they will not be able to recognise the links.

I hope i have explained myself correctly.

Regards

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=535343