Relative file addresses in macros

[Julian]

I am developing a spreadsheet which imports Excel data files using macros. I
will be distributing this spreadsheet to other users. My macros have fixed
file name addresses. Is it possible to specify relative addresses in the
macros for these files so that if the spreadsheet is operated from a
different file/folder, the macros will still work? If so, please advise how
I can achieve this?

Thanks Julian