Before using your spreadsheet with Symphony, debug it with VBAMacroTest.xls. The macro in this spreadsheet performs the exact same steps as the ConnectorForExcel service.
- Register ConnectorForExcel.dll.
regsvr32 ConnectorForExcel.dll
- In Excel, open %SOAM_HOME%\5.1\Integrations\ConnectorForMsExcel\samples\spreadsheets\VBAMacroTest.xls.
- Ensure the ConnectorForExcel.dll is referenced. The VBA code in VBAMacroTest.xls requires the ConnectorForExcel.dll COM object to be properly referenced because it attempts to create an instance of that COM object.
- Select.
- In the Visual Basic Editor window, select .
The VBAProject dialog box opens.
- In the dialog, select the "ConnectorForMSExcel 1.0 Type Library" to place a checkmark in the checkbox.
- Test that VBAMacroTest.xls works with the demo spreadsheet.
- In VBAMacroTest.xls, specify parameters to test the spreadsheet:
Name of spreadsheet to test: ConnectorForExcelDemo.xls
Absolute path to the directory that contains the spreadsheet to test:
For example: %SOAM_HOME%\5.1\Integrations\ConnectorForMsExcel\samples\spreadsheets
- Click the button Excecute Macro.
You should see the following output: