+ Reply to Thread
Results 1 to 2 of 2

get file information from files with http://

  1. #1
    Registered User
    Join Date
    09-14-2009
    Location
    Gothenburg, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    4

    get file information from files with http://

    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?

  2. #2
    Registered User
    Join Date
    11-19-2009
    Location
    erie, pa
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: get file information from files with http://

    if you said that the code works for files on your computer of the network, couldn't you use code to "save" the file, then run your code, then delete the file. I know it's a runaround, but it might spark an idea.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1