Linked File Properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a linked to a csv file and this file is overwritten each day.

I do not have to re link the file but would like to know if it is possible
to get the properties of the actual file ie creation date.

I do not need the creation date of the link as this will remain unchanged.

Does anyone know if this is possible?

Kind regards

Colin
 
Hi!

You can insert below code in any form and call it
Work on A2K, A2K3

'**************************
Private Sub ShowFileInfo()
Dim fso, f1, p1, File1
File1 = "YourFileName" ' ***** insert full path and file name i.e.
C:\temp\data.csv *****
Set fso = CreateObject("Scripting.FileSystemObject")
Set f1 = fso.GetFile(File1)
p1 = f1.DateLastModified
Msgbox "Last modified: " & p1
End Sub
'***************************


Hope this can help You
Best regards
 
Back
Top