Columns Archives - Extra Mile Data

How to time VBA procedures and create a log of elapsed time

by Carl Connett | Nov 5, 2013 | Date, Time, and Age Functions, File Functions, VBA

This set of functions will let you track how long it took for one or more pieces of VBA code to run. The logic includes three sections: name and initialize the timer, end the timer, and write the results to a log file. Here is...

Get total hours and minutes from summing columns of Hours and Minutes

by Carl Connett | Oct 22, 2013 | Date, Time, and Age Functions, Microsoft Access, Number Functions, VBA

This function can be used to return total hours or total minutes from a column of Hours and a column of Minute values. For example, in the table below, an Hours value was captured separately from a Minutes value in a time clock application. If...

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

Count non-Null values across columns in a Microsoft Access record

by Carl Connett | Mar 10, 2009 | Data Type Functions, Microsoft Access, VBA

Need to get a count of the number of columns in the results of a MS Access query that are not Null? This VBA code will do it. Code: Public Function CountValues(Val1, Val2, Val3, Val4, Val5, Val6) As Integer ' This function passes back the...

How to time VBA procedures and create a log of elapsed time

Get total hours and minutes from summing columns of Hours and Minutes

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

Count non-Null values across columns in a Microsoft Access record

Notes

Categories