Office Scripts – Macros on the Web

This example gets you started with Office Scripts in Excel. You'll learn how to record a macro and how to modify the script to get a dynamic range. You'll also learn where to find the Office Script and how to save it with your workbook.

Excel VBA vs Office Scripts

What's the difference between Excel VBA macros and Office Scripts? Do you need to switch from VBA to Office Scripts? Find out in this detailed article. I show examples of what you can achieve with VBA and the current status of Office Scripts and explain what each is for.

Learn Excel Macros

Learn Excel Macros in 10 Minutes If you find yourself repeatedly performing the same steps in the same order in Excel, your brain should immediately declare, “I should automate this with an Excel macro!”. Think of the common, repetitive tasks you perform in

Excel VBA Progress Bar

A progress bar is a great addition for Excel macros that take long to run. It gives your project a more professional touch. It's also quite easy to add. You can create your progress bar once and reuse it in your Excel vba projects.

Understanding and Creating Barcodes in Excel

Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

Excel Get External Links

Get ALL External Links with THIS Simple Excel Trick (as NEVER seen before!) A terrific feature of Excel is the ability to pull data from external sources, like other Excel files. But with any benefit, there comes a cost.  In this case,

Excel VBA GetOpenFileName to Browse and Select File

Dynamic User File Selection Using Excel VBA GetOpenFilename Method This post will demonstrate how we can allow a user to select a file using a traditional “open file”-type dialog box. This has tremendous advantages over hard-coded solutions where the filename and its

Sum Cells by Color

Sum Cells by Color In this VBA tutorial we will look at a way to sum cells based on their background color. Unfortunately, Excel does not possess a function that will provide this functionality. So how will we get this to work?