Philip Treacy, Author at My Online Training Hub • Page 3 of 5

December 13, 2018

Play Audio and Video in Excel

We've had a few forum questions recently asking how to play audio files in Excel. Normally I'd just use my

November 30, 2018

Save Chart as Image

You might want to save your charts as images that can then be used in other applications, like email or

November 22, 2018

Quickly Formatting Markers for Dot Plots

Mynda wrote a post about line charts vs dot plots where one of the steps in setting up the dot

October 24, 2018

Web Scraping Multiple Pages from Websites

My last post looked at web scraping using VBA, where I loaded a single page and extracted content. In this

October 17, 2018

Web Scraping With VBA

We can use VBA to retrieve webpages and comb through those pages for data we want. This is known as

September 19, 2018

Remove Formatting from a Table

Let's say you have a range that you want to convert to a table Something like this that has fills,

September 11, 2018

Listing and Deleting Custom Styles

If you end up with a workbook that contains custom styles, removing all of these may be a pain depending

August 31, 2018

Using SUBSTITUTE Function to Find and Count Text

The SUBSTITUTE function allows you to change text in a string, or a range of strings, but there is more

August 2, 2018

Real Time Data Add-In for Excel

Last week I looked at getting real time data into Power BI using PubNub. This week I want to take

July 27, 2018

Real Time Data in Power BI Using PubNub

In this post I'm going to look at getting real time data (RTD) into Power BI using a real time

July 13, 2018

Using Azure Machine Learning in Excel

In this post I'm going to look at how you can create an Azure Machine Learning experiment to predict diamond

calling vba in an add-in from another vba module

July 3, 2018

Calling VBA in an Add-In From Other VBA Modules

If you've written subs or functions in your own add-in, you can use them in your worksheet as you would

May 31, 2018

Real Time Data in Excel Using Sockets

Last week I wrote about getting real time data into Excel using PyXLL and Python code. I described a way

May 24, 2018

Real Time Data in Excel

Updated April 2020 Excel does support getting real time data into the worksheet with the RTD function, but this requires

April 19, 2018

Timer or Stopwatch in Excel VBA

We had a post on the forum recently asking how to create a timer in Excel, to record how long

April 13, 2018

Volatile User Defined Functions

Excel has the concept of volatile and non-volatile functions. Microsoft define a volatile function as one that is recalculated every

March 29, 2018

ALT Codes for Symbols and Characters

On IBM compatible PC's, many characters that can't be typed on a keyboard can be entered by holding down the

March 9, 2018

AutoSUM Shortcut in Excel

The AutoSum shortcut, ALT+= (ALT and = at the same time), allows you to automatically sum rows and/or columns. How

February 22, 2018

Shortcut for Duplicating Formulae, Text and Objects in Excel

If you want to duplicate something you can copy (CTRL+C) and paste (CTRL+V). But there's a quicker way that only

November 24, 2017

Writing UDFs in Excel With Python

My last post looked at using Python to plot equations in Excel with DataNitro. In this one I want to

November 17, 2017

Plot an Equation in Excel Using Python

Something I've wanted to do easily in Excel is plot equations. If I have something like 2x2 + 3x +

October 26, 2017

Excel 4.0 Macro Functions

Before VBA there were XLM macros. VBA was introduced in Excel version 5, so these Excel macros are also known

September 15, 2017

VBA Shell

The VBA Shell function runs a command in the operating system shell. The shell refers to the interface, typically where

August 10, 2017

VBA SELECT CASE

VBA SELECT CASE allows you to test an expression against multiple conditions, and then carry out a series of commands

August 3, 2017

VBA IF THEN ELSE

The VBA IF THEN ELSE statement lets you test a condition, and then carry out other commands if the test

June 21, 2017

List Files in a Folder Using FILES XL Macro (XLM)

Way back, when Excel 4.0 was around, it used a macro language called XLM. VBA was introduced in Excel 5.0.

June 6, 2017

Script Lab – Explore the Office JavaScript API & Learn to Build Add-Ins

Microsoft recently announced a project called Script Lab, previously known as 'Add-In Playground', which aims to help you learn how

May 12, 2017

More Tips for Debugging VBA

After my last post on debugging VBA I received a few comments with other tips or commands people use for

May 4, 2017

Debugging VBA Code

When you write VBA, or any programming language, you are going to encounter errors in it, or should we call

March 10, 2017

Excel VBA String Functions

If you are working with strings (a sequence of letters, numbers or other characters) in VBA then you are going