Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating COM Objects or Add-Ins from VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating COM Objects or Add-Ins from VBA
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) "JimRWR" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating and Destroying Excel Objects from VB | Excel Programming | |||
Creating and controlling objects in a UserForm | Excel Programming | |||
Creating References To Excel Objects | Excel Programming | |||
Creating References To Excel Objects | Excel Programming | |||
Creating remote objects | Excel Programming |