Ok, this is what I would like to do. I need to access an aspx website that I log into with my own personal login. There is a specific collection data I would like to then navigate to and that is a web form that houses data for my clients. I want to aggregate this form data into an excel sheet. I would use an array of client codes that I would loop through in order to grab data for each client and populate on each row of the excel sheet.
Hurdles to this are I DO NOT want to create a browser object through Internet Explorer or any other browser in order just to automate the browser. So I guess the first step is to know if this is even possible WITHOUT automating navigation through a browser, as this seems to be slow and clunky. Also, once a particular company code is being looped through on the form to obtain their data the web address has no designation of the particular company.
For example: if I were to extract this data by hand I would go here: "https://prodnet.www.neca.org/Login/Login.aspx" I would login and then the browser would take me here: "https://www.neca.org/Neca_Home.aspx". I would then go to this go to this client portion of the website: "http://www.necainfo.org/icc_caf/source/SubmitData.aspx?sarid=XXXXXX". The X's represent the client code. And then click a link to take me to this portion of the site which is a web form "http://www.necainfo.org/icc_caf/source/ResidentialRates.aspx" (The web address at this point does not reflect any designation of the company's code, not sure how big of a problem this is or isn't). From here I would copy the data into my excel sheet.
I more or less know how to populate a excel sheet with HTML data using VBA and I have a general knowledge of programming/coding, however the problems I am having with this project is: Logging into the website using VBA and then accessing the web form without having to automate through a web browser and the appropriate syntax available to help me accomplish my goals efficiently. Any help would be appreciated.
Hurdles to this are I DO NOT want to create a browser object through Internet Explorer or any other browser in order just to automate the browser. So I guess the first step is to know if this is even possible WITHOUT automating navigation through a browser, as this seems to be slow and clunky. Also, once a particular company code is being looped through on the form to obtain their data the web address has no designation of the particular company.
For example: if I were to extract this data by hand I would go here: "https://prodnet.www.neca.org/Login/Login.aspx" I would login and then the browser would take me here: "https://www.neca.org/Neca_Home.aspx". I would then go to this go to this client portion of the website: "http://www.necainfo.org/icc_caf/source/SubmitData.aspx?sarid=XXXXXX". The X's represent the client code. And then click a link to take me to this portion of the site which is a web form "http://www.necainfo.org/icc_caf/source/ResidentialRates.aspx" (The web address at this point does not reflect any designation of the company's code, not sure how big of a problem this is or isn't). From here I would copy the data into my excel sheet.
I more or less know how to populate a excel sheet with HTML data using VBA and I have a general knowledge of programming/coding, however the problems I am having with this project is: Logging into the website using VBA and then accessing the web form without having to automate through a web browser and the appropriate syntax available to help me accomplish my goals efficiently. Any help would be appreciated.
