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 »
In this article, there are 4 ways for you to quickly delete all footnotes or endnotes you have in Word document
In large, endnotes and footnotes are texts in document where explanations and comments go. Yet, sometimes when you inherit a document from others, this kind of information can be useless to you. Therefore, you will have to remove them. Without deleting then one by one, here are 4 quick ways which enable you to clear them once for all.
Method 1: Use the “Styles” Window
First...
Read more »
In this article, we want to show you 2 quick and easy to use methods to extract texts from text boxes in your Word document.
From time to time, we can get a Word file containing a large number of text boxes. Usually, there will be texts or relative contents inside those boxes. Then there can be the need to get only the texts inside instead of keeping the whole text box.
Certainly, it’s quick to retrieve words within one single text box simply by copying the text out and pasting it...
Read more »