Wow time is flying! Looks like my last post was in June! I built this example due to frustration. I was trying to find a way to look at and manipulate appointments in my Outlook calendar for a three month time span. The tool that I built, ultimately loaded the pulled outlook calendar items into a table. I decided not to include that part in this article as it is pretty … [Read more...] about Download Outlook Calendar VBA Example
VBA
How to Find Fourth Thursday of November in VBA
I recently built a project where I had to count business days by excluding weekends and US Federal holidays. In my previous post: , my example used hard-coded dates. This new example can be adapted and re-coded to find the date of any specific weekday or holiday of the year without the need to hard-code. Public Function dThanksgiving(curDate As Date) As Date 'Define … [Read more...] about How to Find Fourth Thursday of November in VBA
Simple Mortgage Calculator Function | Excel, Access VBA
There are a lot of ways to calculate a mortgage payment in Excel. I honestly haven’t made any attempts to calculate a mortgage payment in Access using standard functions. There has to be a way, but for fun, I thought that I would share a simple function. To use this function, insert it into a module. For Excel, make sure you save your Excel document as a "Macro-Enabled" w … [Read more...] about Simple Mortgage Calculator Function | Excel, Access VBA
File Dialog Save-As in VBA Export Table by Name | Microsoft Access
Sometimes it is necessary to export a table to create a backup, share data with a team member, or whatever... Here is how you export a table using the File Dialog object in Access with VBA. This example will work in Access 2007 - 2013. UPDATE 02/16/2015: Added reusable code for file save-as dialog box. Create a new module or add the following code to an existing … [Read more...] about File Dialog Save-As in VBA Export Table by Name | Microsoft Access
Set Appointment in Outlook With VBA in Access or Excel 2010, 2013
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