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 : FolderExists Method
3. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
4. FileSystemObject : MoveFile Method
5. FileSystemObject : GetParentFolderName Method