Visual Basic for Applications (VBA)

<< Click to Display Table of Contents >>

Navigation:  Developer Edition >

Visual Basic for Applications (VBA)

Previous pageReturn to chapter overviewNext page

 

With the Developer edition of Synkronizer, you are able to create recurring, standardized and/or complex comparisons. To access the automation functionality of Synkronizer, you need to have knowledge about Visual Basic for Applications (VBA). With VBA, you are able to you create your own powerful comparison macros.

 

We have provided some simple VBA Examples and a "Wrapper" Procedure to simplify you work.

 

To test the examples, download the example file synk11vba.zip from our server, unzip it and copy the files to a folder of preference.

 

You can also manually test the examples by using the following steps:

 

1.Ensure that Synkronizer 11 Developer is installed.
2.Start Excel
3.Open a (new) workbook
4.Open the VB Editor (keyboard shortcut Alt-F11)
5.Select your workbook in the Project Explorer window
6.Select menu Tools/References, scroll to 'Synkronizer 11.0 Object Library', check it, and press ok.
7.Select menu Insert/Module
8.Copy the Helper Functions into this module.
9.Select menu Insert/Module
10. Copy the VBA Examples into this module.

 

 

The Object Model Reference of Synkronizer 11 is described in the following chapters.