Skip to content
Write a review
UdemyExcelPaid courseExpert levelCertificate

Web Scraping Using Excel VBA (Udemy.com)

Web Automation made easy with VBA

4.5
62 reviews

Created by: ajay parmar

Last updated July 2022

icon
What you will learn

  • How to scrape website using Internet explorer browser.
  • Complete tutorial from basics to advance - Using VBA
  • You will learn everything - from clicking on website links to putting the information in web forms.
  • From debugging the issues to clicking on the links to scrape web page tables using different ways
  • How to launch a website but before launching the website, know the libraries we need it.
  • If website takes time to load how to keep code busy in events to avoid it going forward and then throw errors.
  • Work with attributes like name, id and what is their significance.
  • Work with important tags like a tags which helps in clicking on those links which has hyperlinks.
  • How to loop through all elements using collection loop or how to find out the specific element and then work with only that one
  • How to scrape table data into excel. How to target few or each and every table using loops.

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.5 out of 5higher than 39% of them
  • Reviews62#345 of 356 by number of reviews
  • Length8 hourslonger than 61% of them
  • Last updatedJuly 2022earlier than 61% of them

icon
Course Description

  • Webscraping means how to get the information from any website without doing any manual handling.

  • You will be able to download the data from a website or click on buttons or get the paragraphs content, tables contents and so much.

  • This course will teach you how to do the Web Automation via Internet Explorer - No more manual stuff. It can be done using automation now. Please note it is going to be done only by internet explorer

  • Learn every thing about loops use and if conditions in  Web Scraping using VBA in internet explorer

  • This course is Basic to Advance Level Course so you can definitely join it but it does not discusses vba basics.

  • How to work with A tags

  • How to work with Class Tags and what are the class tags. What type of issues one can face while dealing with classes is also something we have discussed.

  • How to work with input tags,ID tags

  • What is a class in HTML and how and why we create them in HTML

  • What is  a document , its class and document elements - object hierarchy discussion

  • How we can click on links in website

  • How to put the information in website forms

  • How to download the excel or csv files from internet

  • Assignments for you to practice

  • How to debug the program if you are not able to click on link despite it is available on web page

  • Use of immediate window to see more properties of tags like A tag,ID,Class,input, headers etc.

  • Export tables details in excel from a web page

  • How to work with already opened web-pages
Read More Expert Expert Level product length iconTime: 8h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

ajay parmar

I have been teaching online from 13 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.

Read More

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.5

62 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Dave on 12/9/2022

Yet again this is another A* course from Ajay. Much of the material is demystified and clearly explained. The teaching style really suits me and clear guidance is given. Excellent stuff.

By Manish Badhani on 7/11/2021

Overall this course is good for beginners. One thing is bothering me that most of the Office web application frameworks are now built on AngularJS. It would be nice if you teach some basics of web scraping from AngularJS framework webpage

By Nestor David Plascencia Garcia on 3/6/2021

Great course, but using Internet Explorer nowadays is really outdated, I would recommend to use HTTP requests instead or at least Selenium since IE will be dead in a few months.

By Jaser Mancao Boko on 11/30/2020

Really newbie friendly, throughout the course all materials are explained carefully. Teaches good programming habits. If you have some questions answers very fast and the answer is spot on and well explained. Really worth it. Thank you!!!

By Rafael Machado Costa on 3/11/2020

The teacher is wealling to learn, to respond and to update the course as needed The comments on his codes are really nice and understandable. It can't get any better than this :) THANK YOU

By Jagdish on 2/11/2020

Ajay is the best tutor I have ever come across. He patiently explains every concept in detail and makes even the most complex things easy to understand. I have purchased 6 excel / vba courses of Ajay Parmar and I am very happy with all these courses.

By Excel Expert on 1/13/2020

great explanation...Thank you teacher. i Just did one project in office. A big thank you. Can you please share your other courses links as you mentioned in this....i like to enroll..

By Brian Mann on 1/7/2020

Your website has changed since this video was made. The education info is still there but somebody taking the class would need to tweak your code to make it work for them as the "training-syllabus" link is no longer on your website.

By Jyot on 12/4/2019

I was not expecting the classroom feel at all. I just felt i was a part of training and instructor is teaching me . I liked and appreciate your efforts which went into this lecture. You spent so much time in explaining and there was no hush-hush. As i keep moving forward i keep getting great stuff.:) Thank you for giving suggestion also for students . I like the idea to write own summary on notepad and to see what i remembered and understood in it. Very keen to use it in my projects. Pls answer the query , if i will ask.It is a new thing for me.

By Gagan Oberoi on 12/3/2019

Hi Ajay, I think there is some technical issue.. Rating given is not for your course. It was for some other course. Let me revise the rating.

Showing all 10 reviews on CourseDuck

Read all 62 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

Web Scraping Using Excel VBA
Visit course on Udemy Write a review
  • Video Duration: icon 8h
  • Price: See price on Udemy
  • Provider: icon Udemy
  • Updated: icon July 2022
  • Level: Expert Expert
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com