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
Microsoft Access
SOLVED: Provider cannot be found. It may not be properly installed
I am writing this one as part two of my post: How to Connect to Access Database with VBScript As part of building the above example, I kept experiencing this error. I found out that 64 bit Windows 7 and Windows Vista don't have the ability to run VBA in 64 bit. You have to force it to use the 32 bit driver. Have you ever encountered: Error: Provider cannot be found. It may … [Read more...] about SOLVED: Provider cannot be found. It may not be properly installed
How to Connect to Access Database with VBScript
I am posting this one because it took me a little while to find a solid solution. Everything I found had an answer, just not an answer that works. With this solution, you will be able to connect to and pull data from an MS Access database with VBScript. So without further ado, here is the example: Access Source Data For this example, I am using a database stored in a folder … [Read more...] about How to Connect to Access Database with VBScript
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" … [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