Be the first user to complete this post
|
Add to List |
FileSystemObject : GetFile Method
Description:
Returns a file object corresponding to the file in a specified path.
Format :
objectOfFileSystemObject.GetFile(filespec)
objectOfFileSystemObject: As the name says, it’s a FileSystemObject.
Arguments:
- filespec
- Mandatory
- Type: String
- Specific file path
Function FnGetFile(strSpecificFilePath) Set fso = CreateObject("Scripting.FileSystemObject") Set file = fso.GetFile(strSpecificFilePath) s = file.Path & "<br>" s = s & "Created: " & file.DateCreated & "<br>" s = s & "Last Accessed: " & file.DateLastAccessed & "<br>" s = s & "Last Modified: " & file.DateLastModified End Function
Call FnGetFile ("c:\New Folder\file.txt")
Also Read:
- FileSystemObject : MoveFolder Method
- FileSystemObject : CopyFolder Method
- VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
- FileSystemObject : GetFolder Method
- Excel-VBA : Insert Multiple Images from a Folder to Excel Cells