Office File Recovery

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 »

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 »

2 Correct Ways to Change a Bookmark Name in Your Word Document

In the bellowing article, we would like to provide you with 2 correct ways to change a bookmark name in your Word document. While drafting a long Word document, bookmarks and cross-references can become our best friend by saving us a lot of time re-explaining the same point. However, unexpected issue can occur. For example, if you change a bookmark name and update the cross-references, you will certainly fail and end with reference errors such as bellow: The reason is that the time you...

Read more »