Is this a valid file path?

[Lol999]

Hi, could just do with some advice on network file paths. I have got an Excel s/s that exports data to a Access d/b via vba behind a button. In development the file path has been c:\ etc etc

Now however the files are to be networked and the filepath I have been given is thus:
office(\\brfile) (o/Admin

does this look "correct"?

Cheers, Lol

 

[isladogs]

I think you know the answer to this already ... no

 

[Lol999]

Morning Ridders, I assume you mean allowing for the fact that the smiley face is actually a colon and a closing bracket?

 

[isladogs]

Well that clearly didn't help...!

 

[Minty]

To jump in here - Always only use the UNC path type location in your code, Not a specific assigned drive path. The drive path could be different on different machines. So

\\YourFileServer\DataFiles\YourDatabase.mdb

will always work from any machine that can get to that network share

O:\DataFiles\YourDatabase.mdb

Probably won't .

 

[moke123]

following on Minty's comment, heres a helpful function that will convert a mapped drive to a UNC path.
I'd credit the author if I knew who it was.

Function GetUNC(strMappedDrive As String) As String

    Dim objFso As FileSystemObject
    Set objFso = New FileSystemObject
    Dim strDrive As String
    Dim strShare As String
    
    'Separated the mapped letter from
    'any following sub-folders
    strDrive = objFso.GetDriveName(strMappedDrive)
    
    'find the UNC share name from the mapped letter
    strShare = objFso.Drives(strDrive).ShareName
    
    'The Replace function allows for sub-folders
    'of the mapped drive
    GetUNC = Replace(strMappedDrive, strDrive, strShare)
    
    Set objFso = Nothing    'Destroy the object
    
End Function

 

[isladogs]

Hi

Yes I recognise that function
I believe its by Chris Page
See https://pagecommunication.co.uk/2014/07/15/vba-to-convert-a-mapped-drive-letter-to-unc-path/

 

[moke123]

Thanks colin. I updated my snippets db to credit him.

 

[isladogs]

You're welcome -
I've also used that code in the past but like you forgot its source.
I had to do a Google search myself to remind me where it came from.