VBA to validate UNC path

Hi everyone,

I'm failing to get this working.
So, I have a file save on a shared drive that anyone can map differently (M: Z: etc). The thing is, that file can only be used THERE, so if they copy and open it from any other place, the file is deleted.

I've defined "Path" to be on cell B8 as this: \\IRLDUB02.eu.company.net\swg03\ABC\

The piece of code is:

Please Login or Register  to view this content.

As I can understand the problem is that Application.ActiveWorkbook.Path is "reading" the mapped path. E.G. Z:\ABC instead of the UNC one.
Does someone know how can I force it to use the UNC instead?

Thank you.

Use

Please Login or Register  to view this content.

And here is some useful code:

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

I use the following UDF's to convert from UNC to Mapped and back.

Please Login or Register  to view this content.