Signature (Visual Basic / VBA)
Public Function SeparatePathAndFile( _
ByRef rPathName As Variant _
, ByRef rFileName As Variant _
, ByVal vPathName As Variant _
) As Boolean
Code Examples
Assuming
Dim strPath As String
Dim strFile As String
for example
SeparatePathAndFile(strPath, strFile, "\\SJS4\Entisoft\Tools") = True
leaves
strPath = "\\SJS4\Entisoft"
strFile = "Tools"
vPathName rPathName rFileName
--------------------- --------------- -------------
C:\ C:\
C:\Temp C:\ Temp
C:\Temp\Win.Tmp C:\Temp Win.Tmp
\\SJS4\C\Temp\Win.Tmp \\SJS4\C\Temp Win.Tmp
\\SJS4\Entisoft\Tools \\SJS4\Entisoft Tools
Parameters
| Parameter | Description |
|---|---|
| rPathName | String or Variant that will receive the drive and directory path portions of vPathName. |
| rFileName | String or Variant that will receive the file name portion of vPathName. |
| vPathName | The path name that will be separated into its drive/path and file name portions. If vPathName is Null or cannot be fixed-up to a string, this function sets both rPathName and rFileName to an empty string then returns False. |