2 visual basic for applications (vba) – HEIDENHAIN MSE 1000 User Manual

Page 109

Advertising
background image

Operating information

Asynchronous message thread

Operating Instructions

109

9.4.2

Visual Basic for Applications (VBA)

The MSEvba.xlsm spreadsheet uses the mswinsck.ocx, dblist32.ocx, and richtx32.ocx
ActiveX control. These controls are installed with MSEsetup.

The Windows registry entry is modified in order to utilize the winsock ActiveX control.

HKLM\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{248DD896-
BB45-11CF-9ABC-0080C7E7B78D}

To open the MSEvba.xlsm spreadsheet:

Navigate to C:\Program Files\HEIDENHAIN\MSEsetup\Excel.

Double click the MSEvba.xlsm file.

A dialog window appears requesting verification to initialize ActiveX controls.

Click «OK».

The spreadsheet will always make sure the ActiveX compatibility is set correctly
since the registry entry is overwritten when Microsoft updates are performed.

The spreadsheet file should be copied or saved into the user’s directory in order to
create additional functionality.

To access the VBA procedures and winsock usage:

Enable "Show Developer tab in the Ribbon". Refer to the documentation provided
with the software for instructions.

Click on the "Developer" tab.

Click on "Visual Basic".

Advertising