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.
So appreciate your help providing the VBA code to extract the last date or modified date from a html url.
Regards
Andres
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.
VBA Code:
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