Backlinks Add to book Export to PDF Rename Page Book Creator Add this page to your book Book Creator Remove this page from your book Manage book (0 page(s)) Help Getting started with the IP-S7-Link .Net Advanced COM in Microsoft Excel © by TIS After installing the IP-S7-Link .Net Advanced COM using the Windows Installer Package provided you need to perform the following steps to integrate the library within your Microsoft Excel Workbook to take use of its API in your VBA Macros: Ensure that Excel does display the developer tools menu band (in german: Entwicklertools). To do so go to the Excel Options (in german: Optionen) and select the menu band configuration (in german: Menüband anpassen). Then activate the developer tools menu band. Select the developer tools menu band (in german: Entwicklertools). Then click on view code (in german: Code anzeigen). This does open the integrated development environment (IDE) to develop your Visual Basic for Applications (VBA) Macros. Select the Extras menu item (in german: Extras). Then click on the references menu item (in german: Verweise). This does open the references dialog. Using this dialog you are able to add additional library's to your Excel Workbook to take use of their functionality provided developing your VBA Macro. Select the browse button (in german: Durchsuchen) to pick up the type library file (*.tlb) which describes the library (*.dll). This file is used by the IDE to recognize the classes, methods, etc. provided by the library. Navigate to the installation folder selected during the setup procedure here we have the default installation location: C:\Program Files\Traeger\IP-S7-Link Advanced for COM\. When the appropriate installation folder has been opened select the IPS7LnkNet.Advanced.Com.tlb file and confirm with the open button (in german: Öffnen). After selecting the IPS7LnkNet.Advanced.Com.tlb you will now find an entry in the references list with the name “Traeger IPS7LnkNet Advanced COM” which is already checked. In case it is not just set your tick. Finally confirm and add the new reference to your Excel Workbook by clicking the OK button. After the required reference has been added you are now able to get started with our samples.