HSC Chemistry® 6.0
27 - 1
Peter Bjorklund
August 10, 2006
06120-ORC-T
27. Excel Add-In Functions
27.1 Getting started
With HSC 6.0 Add-In Functions it is possible to use the HSC 6.0 database directly under
MS Excel 2000 and in that way carry out several thermochemical calculations. In order to
use these functions in Excel they must, however, first be activated. Three stages may be
needed to activate HSC functions in Excel. The number of stages needed depends on the
computer settings and Windows and Excel versions.
Activation Stage 1:
1. Open Excel 2000 (NOTE: HSC Add-Ins may not work under earlier Excel versions!)
2. Select “Tools, Add-Ins...” from the menu.
3. Select “Browse…” and locate HSC6.XLL from your HSC6\AddIns folder.
4. Select “HSC 6.0 Functions” and press “OK”, see Figure 1. It may be necessary to
restart Excel in order for the add-in functions to work.
Figure 1: Adding/removing HSC 6.0 Functions under Excel Please do NOT select old
HSC 5.1 Functions!.
Activation Stage 2 (Optional):
If the installation is unsuccessful, the following steps may help:
1. Start the VBA Editor by pressing Alt+F11.
(or select Tools, Macro, Visual Basic Editor, ...)
2. Select “Tools, References” from the menu.
3. Select “Browse…” and locate HSC6.XLL from your HSC directory (for example
C:\HSC6\HSC6.XLL). It may be necessary to restart Excel in order for the add-in
functions to work. HSC Add-In functions locate in HSC6.DLL, however, Excel calls
these functions through HSC6.XLL interface.
4. See also stage 3 in Chapter 27.2 if needed.
The HSC installation routine automatically takes care of the HSC6.DLL registration.
HSC Chemistry® 6.0
27 - 2
Peter Bjorklund
August 10, 2006
06120-ORC-T
Activation Stage 3 (Optional):
1. During opening, answer No when prompted by Excel to update all linked
information (automatic link updates do not work due to some bug in MS Excel).
2. Select “Edit, Links” from the menu.
3. Choose the path con