A couple of years ago, I posted code for selecting a file with VBA. This example demonstrates how to use the file dialog to return a Save-As string. VBA File Dialog Save-As ‘————————————————– ‘ File Dialog Save-As ‘————————————————– ‘NOTE: To use this code, you must reference ‘The Microsoft Office 14.0 (or current version) ‘Object Library […]
VBA Export to CSV From SQL With Save-As in Access
Although not as common as exporting to Excel, some projects may have a need to export in .csv format. Here is my solution. VBA Export With User Defined SQL Query This example uses the QueryDef function. Basically, the user passes a SQL query in, the file dialog prompts for where to save-as and the export […]
Download Outlook Calendar VBA Example
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 […]
Create a Folder For Every Tuesday for One Year
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 […]
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. […]