VBA-Excel: Perform Google Search on Internet Explorer using Microsoft Excel

This article will teach you about how you can perform a google search on Internet Explorer using Microsoft Excel.

Steps:

  • Create the object of Shell Application
  • Get all the windows using shellobject.Windows
  • Navigate all the windows
  • check if window is Internet Explorer.
  • if window is IE then check if it is Google Search browser and store the object
  • Get the Page object of Google Search window.
  • Iden­tify the objects on the Page using “GetElementById” and “getElementsByName”
  • Put the search text
  • Wait for 3-4 secs
  • Click the Search button

Read moreVBA-Excel: Perform Google Search on Internet Explorer using Microsoft Excel

VBA-Excel: Login To Already Opened GMAIL In An Internet Explorer (IE)

To Login To Already Opened GMAIL In An Internet Explorer (IE) using Microsoft Excel,

Steps:

  • Create the object of Shell Application
  • Get all the windows using shellobject.Windows
  • Navigate all the windows
  • check if window is Internet Explorer
  • if window is IE then check if it is Gmail browser and store the object
  • Get the Page object of Gmail window.
  • Iden­tify the objects on the Page using “GetElementById”
  • Set the Authen­ti­ca­tion details in the Gmail login page
  • Iden­tify the Sign In But­ton using “GetEle­ment­ById” and Click on it

Read moreVBA-Excel: Login To Already Opened GMAIL In An Internet Explorer (IE)

VBA-Excel: Get ALL The Opened Internet Explorer (IE) using Microsoft Excel

To Get all the already opened Internet Explorer s(IE) using Microsoft Excel, say for example you several IE tabs are opened and you want to get all the information like their HWND property, URLs and Title.

Steps:

  • Create the object of Shell Application
  • Get all the windows using shellobject.Windows
  • Navigate all the windows
  • check if window is Internet Explorer
  • Get HWND property of Internet Explorer
  • Get Title of Internet Explorer
  • Get URL of Internet Explorer

Create the object of Shell Application

Read moreVBA-Excel: Get ALL The Opened Internet Explorer (IE) using Microsoft Excel

VBA-Excel: Launch Mozilla Firefox using Microsoft Excel.

To launch the Mozilla  Firefox using Microsoft Excel, follow the steps mentioned below

Steps:

  • Create the object of WScript Shell
  • Call WScript.Shell Run() Function and provide the complete path for FireFox.exe
  • Set the object of WScript Shell to Nothing

Complete Code:

Read moreVBA-Excel: Launch Mozilla Firefox using Microsoft Excel.

VBA-Excel: Automate Internet Explorer (IE) using Microsoft Excel – Login into Gmail.

To Automate the Internet Explorer (IE) using Microsoft Excel, say for example you want to login to your gmail account using Microsoft Excel. Please follow the steps mentioned below

Steps:

  • Create the object of Internet Explorer
  • Make the Internet Explorer visible
  • Navigate to the “www.gmail.com”
  • Wait till the browser is busy and page is fully loaded
  • Get the document Object
  • Identify the objects on the Page using “GetElementById”
  • Set the Authentication details in the Gmail login page
  • Identify the Sign In Button using “GetElementById” and Click on it

Read moreVBA-Excel: Automate Internet Explorer (IE) using Microsoft Excel – Login into Gmail.

VBA-Excel: Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel.

To Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel, follow the steps mentioned below

Steps:Create the object of Internet Explorer

  • Make the Internet Explorer visible
  • Navigate to the specified URL
  • Wait till the browser is busy and page is fully loaded
  • Create WshShell (Windows Script Host) object
  • Use send keys function to maximize, minimize and restore operations

Read moreVBA-Excel: Maximize, Minimize and Restore Internet Explorer (IE) using Microsoft Excel.

VBA-Excel: Launch Internet Explorer (IE) using Microsoft Excel.

To launch the Internet Explorer (IE) using Microsoft Excel, follow the steps mentioned below

Steps:

  • Create the object of Internet Explorer
  • Make the Internet Explorer visible
  • Navigate to the specified URL
  • Wait till the browser is busy and page is fully loaded

Create the object of Internet Explorer

Set objIEBrowser = CreateObject(“InternetExplorer.Application”)

Read moreVBA-Excel: Launch Internet Explorer (IE) using Microsoft Excel.

VBA-Excel: Working with Internet Explorer

You can perform various operation on Internet Explorer (IE)  using your excel, like Launch IE browser, navigate to specific URL, Click on Images on IE, setting text in input box or web edit and many more.

Since its and external application, to deal with it first step would be get the instance of the word file or you can say create the Object of the word file using CreateObject Function.

Set objIEBrowser = CreateObject(“InternetExplorer.Application”)

And that’s it Now you are all set to perform various operations.

Read moreVBA-Excel: Working with Internet Explorer