Located in %SOAM_HOME%\5.0\Integrations\ConnectorForMsExcel\service. The service acts as a wrapper to Excel, and uses the information passed from the client: spreadsheet name, macro name and two parameters for the macro to invoke Excel on the compute host and execute the macro.
The VBA macro formats its result message and returns the result to the service. The service then sends the result back to the client. The service closes Excel upon completion of the task.
The service also contains ConnectorForExcel.dll, which is a service DLL used to invoke Excel.
Located in %SOAM_HOME%\5.0\Integrations\ConnectorForMsExcel\samples\spreadsheets. Actual spreadsheet that contains the business logic to perform calculations in Excel. Contains the MyMacro VBA function. The client sends this spreadsheet as common data for the ConnectorForMsExcel Service to process.The demo spreadsheet can be used as a template for modifying your own spreadsheets to work with the ConnectorForMsExcel service.
Used for troubleshooting. Parameters for DialogSniffer are configured in the application profile. Detects dialog boxes that appear during the execution of a task, and writes the dialog box text to a log file. Can dismiss dialogs based on text patterns specified in the application profile so that Excel can continue calculations.