Office File Recovery

How to Escape Quoted Strings for SQL Statement used in Database via Excel VBA

SQL Server uses pairs of single quotes to identify the start and end of a string. Inserting 'Mrs Brown's Boys' into a database table will fail since the three single quotes imply two strings, one of which is incomplete. An escape character is required for the apostrophe after Brown. This article explores the use of a customised VBA function to resolve this anomaly. This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google...

Read more »

How to Utilize Conditional Events to Present Data in Different Levels of Details

Spreadsheet rows can trigger context-sensitive events by using the "BeforeDoubleClick" event. In this simple exercise we illustrate how to drill-down from an executive report to the data below. This article assumes 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". The workbook to be used has a number of populated sheets. Please use the one found here for this exercise. The...

Read more »

2 Ways to Prevent Others from Deleting Watermark in Your Word Document

In today’s post, we are thrilled to present you 2 ways to prevent others from deleting watermark in your Word document. It’s not uncommon nowadays to mark a Word document through adding watermarks. In Word, you can choose either a default watermark style or custom your own one. What you need to know is that watermarks are always anchored to header and footer, so an accidental deletion of watermarks is not very possible without entering header or footer. However, to remove watermarks...

Read more »