I honestly have no idea how much traffic this article is going to get. I wanted to post it simply because I thought it was neat. This script was designed to automatically generate a folder name of 'mmddyyyy' for every Tuesday date of a year that a user inputs. This script can be copied and pasted into notepad and saved to where the folders need to be generated with a filename … [Read more...] about Create a Folder For Every Tuesday for One Year
Archives for June 2014
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
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