get full path, even with mapped drives

Hi,

in my office we have a procedure to get the full path of any file, to avoid sending each other links to user-mapped drives
however, the procedure we had it's not working anymore

does anyone have a procedure to that that works in Windows 7 (64bit) & Excel 2010 (32bit) ?

thank you!

here is the procedure I am using now, for your reference (I got it probably here)

Please Login or Register  to view this content.

hi,

a collegue of mine solved the problem with a much shorter procedure, no apis required.

Please Login or Register  to view this content.