2010-08-27

Exposing C# to VBA via COM

I recently toyed with creating a C# project that can be used to expose methods to VBA via COM automation. The project implements one form for printing, but otherwise has no UI. Included is a text file showing how to access and execute the methods via VBA. The project includes multiple methods:

C-Sharp form, printing and formatting options

C-Sharp OLAP connection-related methods

C-Sharp refresh pivot methods

The zip file containing the source code and a text file with VBA to access the COM automation is available from one of my other sites.