Is there a way to define the actual server name in the file name field when
using a macro that imports a file?

I have a macro that imports a file from z:\a_temp but every one in the
office has this drive mapped different rather than go to everyone in the
office  I would like to just define it as SERVERNAME:\a_temp if possible.  

Thanks in advance.