For most cases, you are often using VBA code to do various tasks in Your Word. However, do you really get hang of the steps to run VBA code? Therefore, in this article, we offer a detailed description of those steps for you.
In the followings, we take Word 2010 as an example to show the detailed steps. And you can easily apply the method to other versions in a similar way.
Step 1 Open the "Developer"
First of all, go to the “File”, and click “Options”.
Next click “Customize Ribbon”...
Read more »
Collecting all the file names in a worksheet is very important to your work. In this article, we will introduce a method to input all the file names into a worksheet by using VBA macro.
In our previous article 2 Methods to Copy the List of All File Names in a Folder into Your Excel Worksheet, we have introduced two methods to list all the file names in a folder into a worksheet. And now we have found another method. You can also use the VBA macro to finish this task. Follow the steps below...
Read more »
Excel has a wide range of usage. In this article, we will show you how to create a calendar in a worksheet by using a macro.
Except for storing and analyzing data in your Excel, you can also use it to finish other tasks. For example, you can collect information by using Excel, or you can note down your planning in the worksheet. Today we have found a new usage. You are able to create a calendar in a worksheet. You can see the effect in the image below.
You can input some tasks into this...
Read more »
