download file from webpage with vba

[spq24]

Hello,

I need to download a file from a webpage. The actual link is a javascript link that references what was filled out in a form.

he's the sequence: click a link on a webpage, a popup pops up with a form, I don't fill out anything on the form and I click submit.

is it possible to replicate this process using code?

 

[Ruddles]

Yes, in general terms you need to start an instance of Internet Explorer, navigate to the URL in question, then click the button programatically. To do that you'll need to look at the HTML code for the button to ascertain its name and type, then use the appropriate method to click it.

If that gives you enough to be getting along with, then good. If it doesn't, then we're going to need to look at the Web page so we can see what we're dealing with.