Hello,
I have the following code:
Sub fileModified()
Dim fso As New FileSystemObject
Dim f As File
Set f = fso.GetFile("https://something.somewhere.com/blabla.xls")
FileDate = f.DateLastModified
Range("A1") = FileDate
End Sub
The code works well if I use it for files on my computer, or on the network, but it returns "file not found" when I use it for the above location. So therefore I wonder if the FSO don't work if the files are located outside the network. Are there any other methods that I could use to return the last modified date for the file instead of FSO?
Bookmarks