VBA allows us access to the windows environment to rename a file. In this post, we will look at 5 examples of renaming files with VBA. Rename a File VBA To rename a file with VBA we use the Name command. Example 1: Renaming a file This example renames a file from Example File.xlsx to Read More
Category: VBA
7 ways to remove additional spaces in Excel
The space character for an Excel user can be a real problem. When exporting data from various IT systems, that export will often include extra spaces around values. Finding and removing additional spaces is a crucial skill for every Excel user. We often can’t see the space characters, but Excel sees them. This can cause Read More
Unblock Macros downloaded from the internet
Macros are a great way to automate Excel; they give us a lot of power to interact with, not just Excel but other Office applications. Unfortunately, hackers know about this power too, and can use files containing macros to distribute malware to PCs and entire networks. Microsoft are making changes so that any office files Read More
Excel – Create multiple PDFs based on a list
I was on a call recently where somebody asked if it was possible to create a unique PDF for each item in a list. The answer is “Yes”, so in this post, I want to show you how to do it; how to create multiple PDFs based on a list in Excel. Download the example Read More
VBA to sort sheets alphabetically
When working with Excel, the worksheets order matters. The tabs should reflect the flow which a user can understand. Since there is no native feature to do it, using VBA to short sheets alphabetically can be a useful time-saver. But things are never as straightforward, are they? Sorting can be in standard or reverse order Read More
VBA to hide all sheets except one
There is a common question that many Excel users ask: “How can I hide all sheets except one with a macro?”. So, let’s answer that very question. First, I’ll share with you the VBA to hide all sheets except one, and then the process to turn it into a reusable code block. Basic VBA code Read More
Insert file path into cell with Browse button
In this post, I’ll show you the answer to a question that somebody recently sent me. “If you would want to add a browse button right beside the cell that contains the file path so that you won’t need to manually copy and paste the file path in the cell, how would you do that?” Read More
Excel VBA for Pivot Tables
Pivot Tables are a key tool for many Excel users to analyze data. They are flexible and easy to use. Combine the power of Pivot Tables with the automation of VBA, and we can analyze data even faster. This post includes the essential code to control Pivot Tables with VBA. Download the example file I Read More
VBA Code to insert, move, delete and control pictures
While it is not often that we have to control pictures or images within Excel, based on the number of Google searches for this topic, it’s clearly something people want to know more about. This post serves as a reference to cover most of the scenarios we’re likely to encounter to copy, insert, move, delete Read More
VBA code to copy, move, delete and manage files
Automating processes with VBA can involve copying, moving, deleting and managing lots of files. Thankfully, VBA has many built-in functions to undertake these tasks for us. These files do not necessarily need to be Excel workbooks; they can be any file type. Download the example file I recommend you download the example file for this Read More
