Creating COM Objects or Add-Ins from VBA

G

Guest

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
 
C

Chip Pearson

I have several pages related to writing COM Add-Ins using VB6. Start at

http://www.cpearson.com/Excel/CreatingCOMAddIn.aspx

Note that while the code will transfer rather simply, the matter of forms is
different. There is no way to convert a VBA UserForm to VB6 Form. You can
include a UserForm as a Designer, but that is not really a good way to go.
You'd really have to recreate the forms in VB.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM add-ins 6
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Using COM objects in Excel or VBA? 4
Cannot display Add-in Macro list without going to VBA/Project 5
Process steps to compile current VBA macros into a DLL or COM Addin 1
Creating and using add-ins 1
Creating an Excel Pivot Table using COM in C# producing 0x800A03EC 0
Formatting An Existing Open Spreadsheet With A COM Add-In 5

Top