Closed Thread
Results 1 to 4 of 4

VBA download file using POST

  1. #1
    Forum Contributor
    Join Date
    09-21-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    131

    VBA download file using POST

    Hello all,

    I want to create a VBA code which would download a file from a website. In every day life person presses a button to download a file from a website and the window pops up with question do you want to open it or save it. After looking at website source code this is how button is programmed like:
    5.JPG

    The problem is that there is no direct link to the file as it gets generated once the button is pressed. Is it possible to write a VBA which would download data from a website into the already open worksheet?Below are the snapshots of Firefox network option showing POST parameters sent to the website.

    Any suggestions guys? I'm not an expert so please keep it simple as possible.

    1.PNG
    2.PNG
    3.PNG
    4.PNG

  2. #2
    Forum Contributor
    Join Date
    09-21-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    131

    Re: VBA download file using POST

    Hey guys, I even ready to put money up on a table for the one who does this. How about this?

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: VBA download file using POST

    If you are willing to pay for this help, then I urge you to go to the Commercial Services Section of this forum. Buy Script and post your request in that section. Then ask a moderator to close this thread as you cannot have the thread in the free forum once you have posted to Commercial Services.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Contributor
    Join Date
    09-21-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    131

    Re: VBA download file using POST

    Mods, please close this thread as I have opened the same thread in commercial services group.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] File Download Name assuming Thread Title as File Name Windows 2007
    By jaslake in forum Suggestions for Improvement
    Replies: 10
    Last Post: 03-19-2014, 01:07 PM
  2. Macro to Download csv file from a dynamic date based url to a specified file location
    By srimani202002 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2014, 07:17 AM
  3. Wildcard not working when i download single file from FTP server with .bat file
    By brently in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2013, 05:54 PM
  4. [SOLVED] Download file to update existing file
    By robpopper in forum Excel General
    Replies: 1
    Last Post: 06-13-2013, 09:14 PM
  5. Download Zip File Automatically Through Excel, Zip File is Empty
    By DAK266 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2013, 04:49 PM
  6. Download File with VBA and Replace if File Already Exists
    By DAK266 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2012, 02:07 PM
  7. [SOLVED] How to write a micro to download file at a URL save the file at the local PC
    By www.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2006, 10:21 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