Compatibility with existing VBA application

[R. Marshall]

I have a complex VBA application which works in Word,
Excel and PowerPoint. I would like to convert it to an add-
in, in the hopes that it can be updated and maintained
more easily. (Now, I update the Word project (a ".dot"
file), then export/import into Excel and PowerPoint
projects).

I looked at using Visual Basic to create the add-in, but
it would require a LOT of work, because the form elements
are not compatible. I would have to recreate the forms,
using VB controls in place of corresponding VBA controls,
and there are enough differences in properties and
behaviors as to make the whole thing burdensome.

If I can simply take the VBA forms and code I've written
so far (from the Word project's ".dot" file), and put it
into an add-in project using Office Developer, that would
save me lots of work. Can this be done?

Thanks.

 

[Stephen Bullen]

If I can simply take the VBA forms and code I've written

so far (from the Word project's ".dot" file), and put it
into an add-in project using Office Developer, that would
save me lots of work. Can this be done?

Yes, that's exactly what Office Developer allows you to do - create COM
Addins using the same forms as VBA.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk