Copy and Paste with VBA Excel in Google Chrome Internet Browser

Wednesday, December 4, 2019

The below code enables you to copy and paste at certain x,y coordinates on your internet browser with Excel VBA. You can effectively navigate the web and gather…

Read More

Outlook VBA Startup Event Holiday Reminder

Sunday, November 17, 2019

The below code will automatically check if there's a holiday today. What this code does is runs an Outlook Startup event as soon as Outlook is launched. This…

Read More

Run Excel Subprocedure Module from Outlook Module VBA

Thursday, October 10, 2019

The below code will run an Excel sub from an Outlook sub. By connecting multiple applications in Microsoft Office, you can make more complex programs that automate more…

Read More

Save All Attachments from Outlook into Folder VBA

Thursday, October 10, 2019

The below code counts the number of emails in your Outlook folder Inbox, selects each email one by one, and then saves down all attachments into a folder….

Read More

Connect Outlook to Phone Text Message

Sunday, October 6, 2019

Steps to set-up code. (Please also set-up Rule too as shown in Rule section which shows inbox folder and inbox sub-folder set-ups too. New Code. This version attaches…

Read More

Filter Column by Another Column VBA Excel

Thursday, October 3, 2019

My youtube video at the bottom of this article will walk you through the VBA code to filter one column by a different column in Excel. The below…

Read More

Data Types

Saturday, July 21, 2018

Data types in Excel Visual Basic for Applications differentiate numbers from letters. Data types also differentiate simple integer numbers from decimal numbers. Knowing the different data types will…

Read More

Visual Basic Editor

Friday, July 20, 2018

The Visual Basic Editor screen is the most important screen for writing VBA code in Excel. The below image shows the basic layout of the visual basic editor…

Read More