FileSystemObject : GetAbsolutePathName Method

FileSystemObject : GetAbsolutePathName Method

Description:

Returns a complete Path from a provided path.

Format :

objectOfFileSystemObject. GetAbsolutePathName(providedPath)

Arguments:

• objectOfFileSystemObject
  • As the names says, it’s a FileSystemObject.
• providedPath
  • Path provided to change to a complete path.

Function ShowAbsolutePath(path)
   Dim fso
   Set fso = CreateObject("Scripting.FileSystemObject")
   ShowAbsolutePath = fso.GetAbsolutePathName(path)
End Function

Also Read:

1. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
2. FileSystemObject : GetParentFolderName Method
3. FileSystemObject : MoveFolder Method
4. FileSystemObject : FileExists Method