FileDateTime for URL Html

[Andresuru]

Hi Guys,

Hope you are fine,

Please note I was trying to create a Macro to extract the last update of the link(URL in Html that It is a excel file in a website) using FileDateTime but I guess I am not sure how to do it.

Sub Fecha()

Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False

Dim LResult1 As Date

LResult1 = [COLOR=rgb(184, 49, 47)][B]FileDateTime[/B][/COLOR]("Link needs to be added")

MsgBox ("Last Update : " & LResult1)

End Sub

So appreciate your help providing the VBA code to extract the last date or modified date from a html url.

Regards
Andres