Automation 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 a VBA function to open/get a Microsoft Word document and Find a string

by Carl Connett | Jun 12, 2009 | Automation, Microsoft Access, Microsoft Word, String Functions, VBA

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

Notes

Some operating systems block files that come from other computers. If you cannot get a downloaded file to work properly, right-click over the file, select the Properties option, and then click the Unblock button at the bottom of the General tab.

Use VBA to copy MS Access PivotTable values to the clipboard

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

Notes

Categories