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
Bookmarks