If you are a project manager, this article will help you to easily plan and track tasks in your project and instantly assign a task to your employees. Split the master file and share it with each employee.
Download Now
If you want to start to use the software as soon as possible, then you can:
Download the Software Now
Otherwise, if you want to DIY, you can read the contents below.
Let’s Prepare the GUI
For this tool, we need a macro enabled workbook with 2 sheets. Rename sheet1 as...
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 ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window".
An example of the workbook used in this exercise can be found here.
Uses of dynamic reporting might be:
Reading the...
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 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 »