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