Automation

Hacking Excel: Creating a Search box Automation Tool



66% Off Microsoft Excel Value Bundle

My guest blog post on using Selenium Basic in Excel to automate web navigation, user text entry, and button clicking.

Originally posted on The Hack Post.

ScrenCap

This is a more intermediate level tutorial on Excel Visual Basic, but a beginner tutorial for Selenium Basic. If you are an absolute beginner at working with Excel VBA please visit VBA Tutorial Group: From Beginner to Intermediate, which will guide you through setting up Visual Basic in Excel and working with forms, subroutines, and functions. You should know what functions and subroutines are before proceeding. It could also be helpful if you know what DOM is and have some experience with it.

Now that I have the disclaimer out of the way, shall we begin?

What are we creating?

A tool within Excel that will let you search Google.

Feel free to download the VBA free starter file: Download

Requirements List:

  • A location to type in our search query within Excel
  • A button to tell it to begin searching
  • The ability to return the first page results from a search
  • A screenshot of the search results

View this post in its entirety here: Hacking Excel: Creating a Search box Automation Tool

Advertisements

2 replies »

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.