View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VBA-Beginner[_2_] VBA-Beginner[_2_] is offline
external usenet poster
 
Posts: 3
Default what is filespec ??

I've copied this out of VBA help, and I'm having trouble understanding it.
Can anyone tell me what (filespec) means??

Do I need to enter the file path and name here in it's place??

Sub ShowFileAccessInfo(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = f.Name & " on Drive " & UCase(f.Drive) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
MsgBox s, 0, "File Access Info"
End Sub