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

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 solicitations@jud.ca.gov 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)

• Attachment 1    Administrative Rules Governing RFPs (PDF)
• Attachment 2    JBE Standard Agreement – Terms and Conditions (WORD)
• Attachment 3    Acceptance of Terms and Conditions (WORD)
• Attachment 4    General Certifications Form (PDF)
• Attachment 5    Small Business Declaration Form (WORD)      
• Attachment 6    Unruh and FEHA Certification (PDF)
• Attachment 7    Darfur Contracting Act Certification Form (PDF)
• Attachment 8    One-Way Non-Disclosure Agreement (PDF)
• Attachment 9    Payee Data Record Form (STD204) (PDF)
• Attachment 10  Payee Data Record Supplement (STD 205) (PDF)
• Attachment 11  DVBE Declaration (WORD)
• Attachment 12  Bidder’s Declaration (WORD)
• Attachment 13 Question Submittal Form (WORD)