Hi.

I have a VBA project (Excel 2000) with 11 forms and close to 200 separate
modules (I've maintained a 1:1 relationship between modules and procedures).
I've used public variables, with a couple of exceptions. This application
manipulates PivotTables in order to report out to the user.

I want to be able to compile the code without losing the functionality of
Excel, hence my desire to create a COM add-in.

I've studied various postings in this newsgroup, and sense that
transitioning the code from VBA to VB might be the way to go. Any ideas,
books or resources you'd recommend?

TIA,

Jim