by Carl Connett | Oct 8, 2013 | Date, Time, and Age Functions, Microsoft Access, Microsoft Excel, VBA
This function finds a date a certain number of days from a start date when weekends are not included. It can be used when your work week does not include Saturday and Sunday and you want to find a business day in the future. Microsoft … Tags: Format,...
by Carl Connett | Jul 7, 2009 | Automation, Microsoft Access, Microsoft Excel, PivotTables, VBA
This function uses a combination of Microsoft Access, VBA, and Microsoft Excel to transfer the values from an Access form in PivotTable view to the clipboard. It is a good example of automation using late binding. The Challenge My goal was to automate the process...
by Carl Connett | Jul 7, 2009 | Microsoft Excel, String Functions, VBA
This VBA function returns the first row, last row, first column, or last column of a Microsoft Excel range address. It is also a good example of using a custom enumerated type. A typical range address is a string that defines a rectangle of cells. … Tags:...
by Carl Connett | Apr 24, 2009 | Collections, Databases, Forms, Loops, Macros, Microsoft Access, Microsoft Excel, Modules, Objects, Queries, Reports, String Functions, Tables
This VBA procedure shows you how to create a simple list of the objects in a Microsoft Access database. The list it creates includes the object type, object name, and object description, which can be parsed using the Excel file in the download. Descriptions can...