+ Reply to Thread
Results 1 to 6 of 6

Download workbook using vba from http

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    811

    Download workbook using vba from http

    Hi,

    it is posible to download a copy from cloud or online disk?

    I shared excel for test in google drive:

    https://drive.google.com/open?id=1vy...GJRngtwbSz702g

    And what if i have address like "https://www.test.com/test.xlsx"?

    How to do this?

    Best,
    Jacek

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,664

    Re: Download workbook using vba from http

    Yes it’s possible, however the implementation can be very different depending on the authentication of the website. Do you need to login to the site you actually want to download from?

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    811

    Re: Download workbook using vba from http

    Yes i have to.

    But for google drive how can i do this without password?
    It is shared file for all.

    Best,
    Jacek

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,664

    Re: Download workbook using vba from http

    Workbooks.open will take a url if it is accessible.

    Otherwise, one option would be the second answer here https://stackoverflow.com/questions/...ernet-explorer

    The first answer there may work depending on the type of authentication the site uses (though likely not)

  5. #5
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    811

    Re: Download workbook using vba from http

    hmm still the second macro is not working with my link above and google drive.

    Anyone can help?

    Best,
    Jacek

  6. #6
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    811

    Re: Download workbook using vba from http

    This is not possible to access directly to google drive.
    You have to get Google api credentials...

    I am closing topic.
    Best,
    Jacek

+ 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