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

Brand
Metasys
Product name
Basic Services client library for .NET (and COM)
Metasys API
Document type
API Reference Guide
Document number
LIT-12013522
Version
4.2
Revision date
2021-04-07
Language
English

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 https://docs.microsoft.com/en-us/office/vba/language/how-to/check-or-add-an-object-library-reference.
    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