Call exisitng VBA procedures?

Add-in Express™ Support Service
That's what is more important than anything else

Call exisitng VBA procedures?
 
agent86




Posts: 14
 Joined: 2013-11-16
Add-In Express for VCL
Delphi 7
Delphi XE3


I am brand new to Add-In Express. My questions might be dumb but here goes.

I am creating a custom tab for Word 2010. I have already written VBA code inside Word and a userform. It performs all the tasks I needed to accomplish. My boss decided he wanted the functionality inside the ribbon instead of the userform. My add-in will have 1 tab, 2 groups, 1 dropdown and 4 buttons. Presently each button on the tab I created in Word or the userform I created inside Word calls a procedure inside a module or the userform I created.

1. Are those VBA procedures I already wrote available to call from the Word add-in I am starting to write?
2. Can I add buttons to the new tab inside Word or must all work be done inside Add-In Express?
Posted 16 Nov, 2013 11:01:12 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Hello,

You can call a VBA macro using WordApp.Run. If you create an add-in, you need to create the ribbon UI in the add-in. If you create a Word document/template, you can create Ribbon controls right in the document.


Andrei Smolin
Add-in Express Team Leader
Posted 18 Nov, 2013 03:33:57 Top