Office File Recovery

5 Ways to Quickly Remove Bullets and List Numbers from Your Word Document

In this article, we would like to demonstrate you 5 easy ways to remove the bullets and list numbers from your Word document. A document can contain bulleted and numbered lists. Sometimes, you may need to reformat these lists. For example, you might need to set list contents in bold, italic, or regular texts, to name just a few. Then you have to remove all the bullets and list numbers first. Here are 5 solutions to different cases. Method 1: Set “None” Bullets or Numbering ...

Read more »

How to Call a SQL Server Stored Procedure from Excel VBA

Data on a server can be modified by examining the records ‘client-side’ in Excel VBA, changing them as required, and saving them back to the server. A more efficient way of doing this, particularly if the database is at a remote location and there’s a lot of traffic involved, is to do the work ‘server-side’. This exercise calls a stored procedure from Excel to categorise employees into age-ranges according to their dates of birth (i.e. 18-25 years, 26-35 years, etc.), without a...

Read more »

How to Auto Adjust Combo Box or List based on Dynamic Data Ranges in Excel

Where data downloaded from a database exceeds a combo box’s range, the new items are simply not shown. To counter this, the range that underlies List or Combo boxes needs to expand or contract to match the data.  This article examines how to do this automatically.  It is assumed the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google “Excel Developer Tab” or “Excel Code Window”. A professional way of displaying combo boxes is to...

Read more »