Retrieve Info from Webpage

[LockTheVaught]

Hello,

I'm trying to automate a process by which I log into a system using Internet Explorer via my company's internal website, insert a value from a cell on my excel spreadsheet into a particular field on the webpage, "hit enter" to go through to the next page, and retrieve the "grand total" value from the next page and place that value into a particular column of my spreadsheet. I have very little experience with Macros and VBA, so any help is greatly appreciated.

Thanks!

 

[John_w]

Welcome to MrExcel forums.

Search for "VBA InternetExplorer login" for example code for a start, though your final code will be different to the examples and specific to your website. You need to look at the HTML source of the web pages to see how the login fields and the value input field are defined in terms of HTML element tags, ids and names. The "hit enter" part is usually just submitting a HTML form or clicking a HTML button and waiting for the next page to load.

This thread is a good starting point - http://www.mrexcel.com/forum/excel-...e-ie-input-user-name-password-hit-submit.html.