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