H
Heera Chavan
Hi All,
This code checks the file path of workbook as it should be always on shared
drive.
Function PathAndName() As Boolean
Dim WBPath As String
WBPath = ThisWorkbook.Sheets("Data").Range("B3").Value
'the string length is more the 100 carectors in length.
If ThisWorkbook.Path <> WBPath Then
MsgBox "This workbook is not correct path."
Exit Function
End If
End Function
This small funtion is troubling me a lot. It works on some machines and it
doesnt work on some. Some times it works on my machine and some times i
doesnt.
Kindly help
Heera Chavan
This code checks the file path of workbook as it should be always on shared
drive.
Function PathAndName() As Boolean
Dim WBPath As String
WBPath = ThisWorkbook.Sheets("Data").Range("B3").Value
'the string length is more the 100 carectors in length.
If ThisWorkbook.Path <> WBPath Then
MsgBox "This workbook is not correct path."
Exit Function
End If
End Function
This small funtion is troubling me a lot. It works on some machines and it
doesnt work on some. Some times it works on my machine and some times i
doesnt.
Kindly help
Heera Chavan