Using the Excel sample application - Metasys - LIT-12013522 - Software Application - Basic Services client library for .NET (and COM) - Metasys API - 4.2

Metasys REST Client for .NET and COM Developer Guide

Product name
Basic Services client library for .NET (and COM)
Metasys API
Document type
API Reference Guide
Document number
Revision date

When you want to connect from a VBA application that uses COM Interop on your Metasys server, use the LegacyMetasysClient object. To add references to the Metasys Services Object Library, complete the following steps:

  1. In Excel, enable the Developer tab. Click File > Options > Customize Ribbon > Customize the ribbon > Developer.
  2. To open the editor, click the Developer tab, and click Visual Basic.
  3. Add the appropriate object library reference. For more information, see Microsoft
    If you want to deliver method results to a specific Excel cell, use the VBA editor to access the current spreadsheet and write the client library results. For an example of the results, see the following screenshot.
    Figure 1. Results delivered to Microsoft Excel