Overview
The XLL+ COM Wrapper Generator can be used to generate all the source files of a Microsoft Visual Basic 6 project. The COM object produced from the project will make all the add-in functions of an XLL available from stand-alone programs written in a language that suppports COM, including Visual Basic 6, C++, Visual Basic.NET or C#.
For a project MyAddinLib containing a class MyAddin, the following files are generated:
| MyAddinLib.vbp | Visual Basic 6 project file. |
| MyAddin.cls | Class file containing the COM object source. The class will have one COM method for each add-in function in the XLL. |
| ExcelWrapper.cls | Helper class which controls an Excel application instance. |
Generator requirements
The generator makes use of the following libraries, which are required when the COM library source code is generated. Note that they are not required by users of the compiled COM library.
- Microsoft Scripting Runtime (scrrun.dll)
- Microsoft XML (msxml.dll or msxml3.dll)
- Planatech XLL+ toolkit version 4.2.6 or above.
The template files "projectEA.vbp.txt", "class.cls.txt" and "ExcelWrapperEA.cls.txt" must be located in a sub-directory Templates beneath the directory containing the executable file ComWrapperGen.exe.
Run-time requirements
The compiled COM object requires the following support files at run-time.
- Microsoft VB6 runtime (msvbvm6.dll)
- Microsoft Excel (97, 2000, XP or 2003) or Planatech XLL Host
- The XLL whose add-in functions are being exported
| Further information | |
| Using the wrapper generator | |
| Generated code | |
| Calling the COM methods | |
| Deploying wrapper libraries | |
| Using ComWrapperGen on the command-line | |
| XLL Host | |
See Also
Using the wrapper generator | Generated code | Calling the COM methods