Office Solutions

How to Create a Football Pitch and Ball Pass Logger with Excel VBA

Certain Football fans go a step further and track each ball pass on the field and analyze the game. With this article, you can easily create a software in Excel with which you can easily track each ball pass during a Football match 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 We need two sheets. The first sheet should be named as...

Read more »

How to Rapidly Create a New Follow-up Task Based on an Existing One with Outlook VBA

Have you ever wanted to create a new follow-up task on basis of an existing one? There is no doubt that manually creating is a bit cumbersome. Why not resort to Outlook VBA? This article will guide you how to achieve it. Sometimes, for some reasons, such as after receiving a task from others, you may desire to create another one based on this task for follow up. Generally speaking, the only way for those who have no knowledge about VBA is to manually create a new one from the existing one....

Read more »

How to Check if a String Contains an Alphabetical (Non-Numerical) Character via Access VBA

“Cleaning” information before you import it into your database is pretty standard – after all, one of the reasons you’ve started to use a database is so that you can predictably query that database for set criteria right…right? So how you handle external situations where, for example, you have to import info from a file where one person enters “$” but another assumes you know it’s a monetary value – or worse, where someone enters “am” or “pm” but another person uses...

Read more »