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