Get Network Path of file in VBA

I it possible to select a filename in a VB form (using launchCD or somthing) and instead of getting the filename ("N:\a\pointless\example") getting the

\\server\partition\...... path instead? I'm trying to log a bunch of files in a database but get the old problem that not everyone has the same drive letter as the person next to them.

There is a very thorough code here which if you examine has a function within it to obtain the UNC path.