S
Steph
Hi everyone. The below piece of code checks to see if the current open file
name is the same as a file name in a server folder.
If LCase(file) <> LCase(ThisWorkbook.FullName) Then
If LCase(file) returns a server path like \\servera\folder\folder\folder
LCase(ThisWorkbook.FullName) returns a path like G:\folder\folder\folder
They are the same thing, but according to vb are different. How can I get
LCase(ThisWorkbook.FullName) to return \\servera\folder\folder\folder??
name is the same as a file name in a server folder.
If LCase(file) <> LCase(ThisWorkbook.FullName) Then
If LCase(file) returns a server path like \\servera\folder\folder\folder
LCase(ThisWorkbook.FullName) returns a path like G:\folder\folder\folder
They are the same thing, but according to vb are different. How can I get
LCase(ThisWorkbook.FullName) to return \\servera\folder\folder\folder??