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. FileSystemObject : CopyFile Method
2. FileSystemObject : GetParentFolderName Method
3. Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
4. FileSystemObject : DeleteFolder Method