Programming Office Routing Plus™ With VBA

Many organizations may wish to program Office Routing Plus with Visual Basic for Applications(VBA). Office Routing Plus allows for this, if you have purchased the Office Routing Plus Programming API™. Email for pricing and further details.
Below are a few scenarios that show the potential power of the Office Routing Plus Programming API.
1. You have a saved Microsoft Excel form that your organization uses for check requests, and you want users in your organization to be able to download this template from your intranet or a network location. You do not want the person making the check request to know which all the recipients of this document because you have a large organization with complex business rules. It would be nice to have managed code inside the document itself that could dynamically determine the routing recipients based on criteria in the document. (i.e. the department the initiator works in, the amount of the request, or the type of request.) You can design the Microsoft Excel form so that each of these pieces of information can be clearly determined (i.e. by making named references or ensuring that they are put in specific cell numbers).
A programmer may now write VBA code in the form itself that has logic for looking up the appropriate recipients to route to based on the user’s department and the amount/type of check request. This mapping logic could be stored in arrays or simple function in the Microsoft Excel document or it could even be tied into Active Directory or a company database. Once a programmer has determined the recipients, he could create a button that the user clicks, which could then easily add these recipients to the document with Office
Routing Plus’ programmable API. The code would simply pass in the current Microsoft Excel/Word document to Office Routing Plus API and then add the recipients. The document could also be routed with the API.
2. When a form is filled out on your company website, you may want to write special code to take the data from this html web form and automate creating a new Microsoft Excel or Microsoft Word document (or even a PDF document) with the form’s content. Then you can add recipients to this document based on the content of the document and route it to the first person. This could be accomplished by a programmer who knows how to automate creating a Word/Excel document from managed code written in a language that can interact with COM objects (, c#, etc). Once program automates the creation of the document and adds the recipients with the Office Routing Plus Programming API, it could route the docu-ment to the first recipient with one additional line of code.

If your company is interested in purchasing the Office Routing Plus Programming API,
contact Integrity Solutions at

This entry was posted in Advanced Features and tagged , . Bookmark the permalink.

One Response to Programming Office Routing Plus™ With VBA

  1. Pingback: Alexander7