Linked File Properties

[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

 

[Sinisa Krizanec news]

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