file download no directlink

[hellowit]

I need to download a file from the web. There's no direct link so I can't use URLDOWNLOADTOFILE. To download it I have to click the button in the page. Currently is use click and sendkeys when dialog popups. is there any thing else I could do to get that file link or maybe get it just when the dialog popups?

[Leith Ross]

Hello hellowit,

You can automate clicking the button with VBA . Are you using Internet Explorer as your browser or something else?

[hellowit]

Hello hellowit,

You can automate clicking the button with VBA . Are you using Internet Explorer as your browser or something else?

i did use VBA to automate it and i use document.getelementbyid().value and document.getelementbyid().click and then the download dialog popups and then i use sendkeys to send tab and enter. However it is so unstable.

I just wanna try another method like URLDOWNLOADTOFILE. To my knowledge that only works if I have a direct link to the file I want but in this case I don't. I have to click the <input type="imgae" /> something to download the file.

So any idea how can I just get the direct link. Or is there a way to do what I did but without the dialog prompt for SAVE OPEN CANCEL and just download the file like in firefox or chrome?

thanks

[Leith Ross]

Hello hellowit,

Can you post the URL so I can examine the web page?

[hellowit]

The page needs login so I will give you the page source instead. the page is in .aspx format.

To download I need to document.getElementById('lstYear').value = '2012' and document.getElementById('btnGo').click and then the download dialog box will popups. Need login session to download the file by the way forget to mention that but I have no problem with login.

[Leith Ross]

Hello hellowit,

The source file is of little value since it is the source of the final output. There is no usable information regarding the link address or which script is called by the element when clicked.

[hellowit]

thanks anyway.