When writing automation for certain processes, it is sometimes important to set a follow-up reminder appointment for the next step. For this task, I wrote a very simple script that sets a reminder in Outlook. This script is super simple and can be improved several different ways. For simplicity sake, I decided to leave out the fancy "With" procedure and just use the object … [Read more...] about Set Appointment in Outlook With VBA in Access or Excel 2010, 2013
Archives for March 2014
In a recent project, I had to build a program to calculate an end date in either business days or calendar days based on certain criteria. This solution had to work in both Excel and Access and needed to run without the use of database tables. Business Day Calculation Requirements The criteria I used to determine the definition of a business day was any non holiday weekday. … [Read more...] about Calculate Date in Business Days in VBA Without Database Tables
There are many ways an end user can run into this problem. One of the most common causes that I have seen is when pasting data. Enter the Datatype Sometimes when data is pasted, no matter if it is in a number format from the original source - it can be pasted as text or in string format. Strings are great, they can help display data in a wide variety ways, including numbers … [Read more...] about Why Don’t My Columns Add in Excel?
I also wasn't sure how to word the title, but it seems to make sense. This is a very short post as this is pretty simple. When reporting out on data, there is the possibility that at some point, a report request will call for a count of items by group. I wanted to make this example as simple as possible. To keep it simple, I designed a table with first names(FirstName) and … [Read more...] about How to Count by Item With SQL | Group By Query MS Access
It is always annoying when forgetting passwords. It is also annoying when you inherit a document from a previous employee and it is protected by a password only they knew. But your boss asked for you to get the data from that spreadsheet and change some things and Right now! What are you going to do? Well the good news is that if the document isn't encrypted, this process is … [Read more...] about Crack Microsoft Excel Password Free | Excel 2007, 2010, 2013