Requirements

Excel version

This model uses Excel's RTD mechanism, which is only available in Excel XP upwards. It cannot be used with Excel 97 or Excel 2000.

Operating system

The model requires Windows 2000 or above, since Windows 98 does not support multi-threading.

XLL+

The sample code requires XLL+ 4.3.1 or above.

Deliverables

The deliverables required for the projects discussed here include the following files and folders:

File	Description
Samples/AvgOptAsync	Source code for the asynchronous Excel add-in discussed below.
Samples/XllRtdLink	Source code for the RTD server discussed below.
Samples/Bin/XllRtdLink.dll	Compiled RTD server module.
Include/ThreadManager.h	Simple mechanism for managing a thread pool.
Include/XllRtdLink_common.h	Functions used by the sample XLL to communicate with the RTD server.
Docs/XllRtdLink.pdf	This document.

Installation

The model uses a COM module (XllRtdLink.dll) to support Excel's RTD mechanism. You should register the RTD server module XllRtdLink.dll, in one of the following ways:

1. Use REGSVR32 at the command line, e.g.

   REGSVR32 "C:\Servers\win32\XllRtdLink.dll"

   Ensure that you register the correct version of the DLL: on a machine with 64-bit Excel, you should register the 64-bit version of the file, which can be found in redist\x64, whereas on a machine with 32-bit Excel, you should register the 32-bit version of the file, which can be found in redist\win32.

2. Build the project Samples\XllRtdLink\XllRtdLink.dsp (or Samples\XllRtdLink\XllRtdLink.sln if you are using VS.NET 2002, or Samples\XllRtdLink\XllRtdLink71.sln if you are using VS.NET 2003, or Samples\XllRtdLink\XllRtdLink8.sln if you are using VS.NET 2005). Choose either the Debug or the Release MinDependency build.

Next: Flow >>