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

Use VBA to return a column or row from a MS Excel range address

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

Find duplicates in a VBA array

by Carl Connett | Jun 17, 2009 | Arrays, Loops, String Functions, VBA

This VBA function looks for duplicate values in an array. If it finds some, it produces a list of the duplicated values. It is a good example of how to loop through an array. The argument needs to be an array. Nulls in the array...

Convert a number to a date using VBA

by Carl Connett | Apr 27, 2009 | Data Type Functions, Date, Time, and Age Functions, String Functions, VBA

This VBA procedure converts a number, in yyyymmdd format, to a regular date like mm/dd/yyyy. For example, a number like 20090427 will get converted to 4/27/2009. Code: Public Function DateFromNumber(DateNumber) ' This function returns a date from the DateNumber...

Use VBA to copy MS Access PivotTable values to the clipboard

Use VBA to return a column or row from a MS Excel range address

Find duplicates in a VBA array

Convert a number to a date using VBA

Notes

Categories