Get 15 minutes of free Live Help!

Use VBA to copy MS Access PivotTable values to the clipboard

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

read more

posted on: Jul 7, 2009 | author: Carl Connett

Use a VBA function to open/get a Microsoft Word document and Find a string

This VBA function opens/gets a MS Word document and finds the next occurrence of a specific string. The function provides a good example of using late binding automation and the AppActivate() function.

One advantage of late binding (using generic objects, like objWd in the function)

read more

posted on: Jun 12, 2009 | author: Carl Connett

Live Chat Software