By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Something went wrong.
Something went wrong.
Something went wrong.
dbr2598: 0

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step -1 - FileDateTime(sFileName)

This VBA function will return the date and time of the passed file.

To check for a web file try

sWebURL = "http://url.com/file.zip"

sFile = Replace(Replace(sWebURL,"http://", "\\"), "%20", " "))

s = FileDateTime(sFile)