Many users need to quickly list all files in a Windows folder and all of its subfolders in an Excel worksheet. Therefore, in this article, we will introduce you 3 rapid ways to realize it. If you want to recursively list all files in a Windows...
Read more »The following article shows how to mark out and interrogate a calendar with the mouse. *In the real world, we’d open a form to read and write meaningful diary entries to a database. This exercise simply reveals the mechanics of right_clicking,...
Read more »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...
Read more »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...
Read more »Teachers always have tons of task to complete. They have to prepare notes for tomorrow's class, track student's performance, prepare reports for top management and many more. Let's make the mark entry an easy task for them. Download Now If you...
Read more »There might be several unwanted and unused files eating your disk space. Cleaning these files might be a huge task. With excel, you can easily find such unused files and delete them instantly to free disk space. Download Now If you want to start...
Read more »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 »The Excel ribbon can be modified to suit a particular job. This exercise creates new menus that point users to specific sheets relevant to their task. In this article, we will introduce how to create customized menus in your Excel worksheet,...
Read more »