Category: VBA

Refresh one connection at a time

In some cases you might find that the RefreshAll command isn’t working as you’d hoped. For example, if you have a pivot table looking up data from a SQL database connection you need the pivot table to refresh after the connection but RefreshAll won’t necessarily do that.   To ensure one connection is refreshed at Read More …

Play audio on Microsoft Excel

A little known, quite funky Application command in VBA is to set your spreadsheet to talk to you. You can either input a fixed message like the example below, or use strings to trigger Excel to speak out loud the contents of a cell on a particular event.     Application.Speech.Speak “Have a nice day”