This article explains how to synchronize an Excel spreadsheet with Invantive Control model using VBA calls.

Instructions

The following methods are available:

  • I_SYNC_UPLOAD: upload data to your database or service;

  • I_SYNC_DOWNLOAD: download data from your database or service;

  • I_SYNC_ALL: first I_SYNC_UPLOAD, if successful run I_SYNC_DOWNLOAD.

Execute the following steps to enable use of the I_SYNC_* methods:

  • Enable the Invantive model from the Modeler ribbon using the slider.

  • Set the model in edit mode using the Edit mode button in the same ribbon;

  • Open the Developer ribbon and click “Insert”.

  • Then select the first item Button (Form Control).

  • Draw a button.

  • The “Assign Macro” dialog opens automatically.

  • Click “New” there; the Visual Basic for Applications editor displays.

  • In the menu bar, choose “Tools”.

  • Then choose the menu item “References”.

  • Check InvantiveControlUDFs.

  • Click OK.

  • Now in your sub, place the call to Invantive, such as:

Sub Button2_Click()
    I_SYNC_DOWNLOAD
End Sub
VBNET