Requesting Suggestions about Using Excel VBA with Websites

Please suggest me some good material (Book) name or website which gives some indepth details about Using VBA with XML/HTML to login Websites via coding and performing all the actions which we do manually.

Hi Kyle123,

Thanks a lot for showing some light on my path...

It seems that I have to spend more time to learn all those things

I thought there will be some predefined VBA methods / properties / codes will be available readily and I can do some changes to adapt it to my needs.

But now I understand that I need to spend some time to get in depth knowledge about HTML specifically DOM, a server language - PHP for achieving this.

Seems like beyond level of knowledge, since I don't have that much of time and it's going to be a 1% of automation requirement in my workplace.

So I will continue doing it manually since it requires dedicated learning

Once again thanks a lot for sharing your knowledge which given some good insight for me

If you elaborate on what you do manually it might be easy to answer your question. You don't need full understanding of html to effectively interact in VBA. Some things are very easy, other things very complicated. It also depends on the complexity of the website.

Hi snb,

Thanks a lot for taking time to offer some suggestion on my request

It's our employees cloud service website (given to third party) which stores the work info of all the employee (for example 5000 employees).

But the design is worst which don't allow the user to pull report in single click...

For example it will have main menus inside the web area and selecting the menu will take you to the concerned page (like access form).

When I see the person doing it manually I thought to automate it and I tried to get the names of the heading and use Menu Names and Textbox name and all from the View Source option.

The only thing is that I don't know how to tell it is a texbox("Name") or Menu("Name") in VBA.

Coming to the worst design topic..

	A	B	C	D
1	State	Area	Year	Month
2	26 States	Based on State	One Year Per Selection	One Month Per Selection

I have to select each drop downs manually for getting the data which is useless approach instead of selecting All in one shot.

What happens if the user want to retrieve the data for 5 Years for all employees? It's time consuming and useless approach...

Just wanted to automate the selection in VBA to loop through these (State/Area/Year/Month) by selecting data from excel and getting the data easily without any manual work.

At the same time the server may take 2 to 5 minutes for getting the selected data and the server response time won't be static (unable to use excel vba OnTime) so these things needs to be used in code while trying to retrieve the data from the website programmatically

It all depends of how the site has been build but you could have some luck trying

Please Login or Register  to view this content.