Microsoft Word Visual Basic for Applications (VBA) Macro Modernization, RFP Number RFP-COA-2023-01-RP

Update: March 6, 2024
Notice – Intent to Award

Update: January 11, 2024
Response to Questions

Title:  Microsoft Word Visual Basic for Applications (VBA) Macro Modernization

RFP Number: RFP-COA-2023-01-RP

The Judicial Council of California, chaired by the Chief Justice of California, is the policy-making body for the California court system. The California Constitution directs the Judicial Council to improve the administration of justice by surveying judicial business and recommending improvements to the courts; and adopting rules for court administration.

In 1998, the Supreme Court of California and the Courts of Appeal (“Courts”), in partnership with the Judicial Council’s IT Department, implemented Visual Basic Applications (“VBA”) based macros in Microsoft Word that served to help court staff create documents.  These Microsoft Word VBA based macros (“Macros”) are a collection of functions that users can select to accomplish a set of document-related tasks.  The Macros were used to help staff ensure consistent document structure, assist with automating repetitive tasks, and reduce errors in document creation.  Since their original deployment, these Macros have undergone many revisions and modifications to suit the changing needs of each court and have been in continuous use for twenty-five (25) years.

On behalf of the Courts, the Judicial Council seeks Proposals from a qualified person or entity to assist with the modernization of the Courts Microsoft Word Macros.  The qualified Proposer will examine the current Microsoft Word Macros and work with court designees to identify desired features to add or remove, and then will rebuild the Microsoft Word Macros using Microsoft Word Visual Basic for Applications.

As set forth in the RFP, questions and the signed One-Way Non-Disclosure Agreement(s) should be directed to and must be received no later than 4:00 P.M. Pacific Time, January 3, 2024

As set forth in the RFP, Proposals must be received via email by the Judicial Council no later than 4:00 pm, Pacific Time, February 1, 2024.

Further details regarding the solicitation are set forth in the RFP and related documents provided below:

Request for Proposals (RFP) (PDF)