Macro to download a file by click a button on internet link

Hi there,


I want a macro that goes to a website and clicks a button and downloads an excel file and then I want to copy it into my current file to manipulate.

Please Login or Register  to view this content.

This works wonderfully except it downloads the url which I know is correct in the code but I need to go an extra step as on the URL you need to click 'export to excel' button to download the file.


The relevant HTML code is (I think!!):

PHP Code: 

<td style=" text-align: center; font-size: 12px;">
<input type="submit" name="ctl00$ContentPlaceHolder1$btnExportToExcel" value="Export To Excel" id="ctl00_ContentPlaceHolder1_btnExportToExcel" class="Loginbtn" style="width:191px;" /></td> 


thanks in advance of any help.


Noreen (New User )

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

This one is out of my wheel house. Hopefully someone with expertise in this area will help.

Hello NorrenDeasy,

This might get you going in the right direction. The macro below assumes the button to be clicked is on the login page.

Since you didn't say which page the button is actually on, this is a guide to help you modify your code. Fortunately, the web designer had the presence of mind to use the ID property when writing the code.

Please Login or Register  to view this content.