Note: These instructions are for users of Microsoft Visual Studio .NET or Visual Studio 2005. For a quick start to using XLL+ with Microsoft Visual Studio 6, click here.
After you have installed XLL+, follow these instructions for the quickest possible introduction to using XLL+. You can find out more about any of the steps by clicking on the "More..." links.
- Start Microsoft Visual Studio (.NET or 2005)
-
Use the Tools - Add-ins menu to register the add-in XLL+ Function Wizard.
(You only need to do this once.)
-
Use the XLL+ AppWizard to create a new project. Accept all the default
choices in the Wizard's pages.
-
Open the main CPP source file and use the XLL+ Function Wizard item on
the Tools menu to open the create a new add-in function.
On the Tools menu, click the New XLL+ Function item and then fill in the function's name and description, and press OK.
-
In the XLL+ Function Wizard, add the names types and descriptions of
your function's arguments, and press OK.
-
In DevStudio, add your own code to the skeleton generated by the Wizard, then
build and test your project. For example, you might add the line of code shown
below:
extern "C" __declspec( dllexport ) LPXLOPER EDateDiff(double StartDate, double EndDate, const char* Country) { CXlOper xloResult; //}}XLP_SRC // TODO - Set the value of xloResult xloResult = 99.9; return xloResult.Ret(); }
For a more thorough introduction to XLL+, read through the rest of the topics in the Basic features section.