Help with macro to return a Mapped drive Address.

Hello,

I'm new to this forum and like all the help it has given me so far, but couldn't find a answer to my macro problem.

Basically I'm using "application.worksheet(1).path" to return the path name of the worksheet which is basically:
\\server\documents\excel.xlsm

If I map the documents folder to a drive, it still returns the server path, so instead of: \\server\documents\excel.xlsm

I want it to return with: Z:\documents\excel.xlsm

Is this possible?

Thanks!

Bump

Does anyone have any ideas?

Thanks!