+ 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-365
    Posts
    2,940

    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
    365 Win 11
    Posts
    7,238

    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-365
    Posts
    2,940

    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
    365 Win 11
    Posts
    7,238

    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-365
    Posts
    2,940

    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-365
    Posts
    2,940

    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)

Similar Threads

  1. Replies: 0
    Last Post: 04-09-2017, 07:44 PM
  2. Strange http link message in Workbook with macros
    By LydiasDad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2014, 02:58 AM
  3. Replies: 8
    Last Post: 01-30-2014, 03:12 PM
  4. Download Excel Workbook from IE copy and paste into existing Workbook
    By kboy1289 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-16-2013, 03:13 PM
  5. [SOLVED] .VBS to download workbook daily
    By jayinthe813 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2012, 12:43 PM
  6. macro for automated download file from http login required
    By hellowit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2012, 03:17 AM
  7. how to download url data into current workbook instead of a new one
    By baroda11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2008, 01:57 PM

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