Solutions

How to Open and Populate Template with Excel VBA

Excel Templates are typically workbooks, with a reporting framework, often supported by functions. A templates (xltx) can be used over and again without polluting it with data. After population with data, a template workbook is saved as an xlsx, preserving the virgin state of the xltx itself. In this exercise we will use VBA code  to open and populate a template. The template can be found here and Excel Macro used can be found here. This article assumes the reader has the Developer...

Read more »

2 Methods to Export All Emails from a Specific Sender to an Excel File

If you would like to quickly export the emails which are from a specific sender to an Excel file, you can use the following 2 means introduced in this article. For some reasons, such as making a summary, at times, you may need to export the specific emails, such as emails from a specific sender, to an Excel file. When it comes to exporting, the native feature “export’ will occur to most users’ minds in the first place. But to be honest, using Outlook VBA will be much handier than the...

Read more »

3 Methods to Change the Comment Text Style in Your Word Document

In today’s article, we are delighted to show you 3 methods to change the comment text style in your Word document. As always, Word has default style for comments. And there is a huge possibility that you don’t like it. As a result, it would be nice to be able to change the comment style in your document. You can read on to see our 3 methods bellow. Method 1: Use Shortcuts To begin with, put insertion pointer at the start of the first comment text. Next press “Ctrl+ Shift+...

Read more »