Skip to content

Excel VBA Macro Save .xlsm File to Specific Location as .xlsx | File Name Based on Cell Values

      In this video I demonstrate how to write VBA code to save a macro-enabled .xlsm file as a normal Excel workbook (.xlsx file). In our scenario we have an invoice template that we use to generate our invoices. A command button, when pressed, automatically saves a copy of the invoice template to a specified… Read More »Excel VBA Macro Save .xlsm File to Specific Location as .xlsx | File Name Based on Cell Values

    Find & Replace Multiple Words or Characters at Once in Excel | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

      In this video I demonstrate how to find and replace multiple words at once in Excel. I explore three methods that can be used to achieve this. Click here to download the featured file Video Table of Contents 00:00 Introduction 00:44 METHOD 1: Use VLOOKUP or XLOOKUP for whole word find and replace Here’s the… Read More »Find & Replace Multiple Words or Characters at Once in Excel | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro