Workbook Archives - Extra Mile Data

Use VBA to copy MS Access PivotTable values to the clipboard

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...

Get the name and description of all MS Access database objects

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...

Use VBA to copy MS Access PivotTable values to the clipboard

Get the name and description of all MS Access database objects

Notes

Categories