Demonstrates the use of RTD handles to represent objects in Excel

Overview

This add-in contains a lockable version of the object cache described in the User Guide topic Using object handles.

See the documentation for LockableHandleCache for details of the use pattern. You can find VBA code that makes of handle locks in the demo files LockableHandlesDemo.xls and LockableHandlesDemo.xlsm.

Requirements

To edit the functions in this add-in, you need to load the extension file RtdHandles.xpe. See Loading an extension file for instructions.

You should also make sure that none of the following extension files is loaded, since the various types of handles are mutually exclusive.

• NumericHandles.xpe
• StringHandles.xpe
• StringPtrHandles.xpe

Classes and functions used

psl::CreateHandleInCache | LockableHandleCache<T>

Sample project

Each sample project is located in a sub-directory of the Samples directory of the XLL+ installation. To use the sample project, open the solution file LockableHandles.sln or the project file LockableHandles.vcproj.

You can enable debugging under Excel by using the Setup Debugging command in the XLL+ ToolWindow.

When delivered, the help files are excluded from the build. You can enable the help build by selecting the files LockableHandles.help.xml and LockableHandles.chm in the Solution Explorer, and using the right-click menu to view Properties. Select the page "Configuration Properties/General" and set the "Excluded from build" property to "No". See Generating help in the User Guide for more information.

See Also

List of Sample Projects | Using object handles | NumericHandleDemo sample