It is very common to see people saving confidential data in Excel workbooks. When these workbooks have to be shared with other colleagues or friends, manual deletion is the only option available. However, with this article, you will learn how to...
Read more »This article shows how to refresh a worksheet or chart at regular intervals. This exercise builds a timer that refreshes the worksheet every one minute, reflecting changes in the source data. This article assumes the reader has the Developer...
Read more »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...
Read more »