- Page 59, Problems and Incompatibilities (mouse wheel): The
VBA development environment ignores mouse wheel events for certain
mice. The free tool vbscroll solves this
problem.
- Page 307, User defined functions in Excel 2003: In Excel
2003, it is no longer possible to save a short description for each
function (see figure 5-9, which was taken with Excel 2000). You can
specify a description, but Excel does not save your text. To get
around this bug, open the Immediate Window and type in this command:
Application.MacroOptions Macro:="myfunctionname", Description:="my description"
- Page 383, On Error Goto: The listing test_resume contains
two syntax errors. Please replace On Error Resume ... by On
Error Goto ... (twice).
- Page 747-754, Web services, update for Excel 2003: If you
want to use web services in Excel 2003, you need to download and
install the Web
Services Toolkit 2.01, which has been designed specifically for
Excel 2003.
I experienced some incompatibilities when trying to run projects
which were originally designed with Excel 2002. To get around them, I
had to remove the reference to the SOAP library and then to add a new
reference. Also, I had to remove all modules created with the old
toolkit (all modules named clsof_xxx, clsws_xxx, struct_xxx) and
re-create them.
- Page 750, Web services, sample: The address
www.perfectxml.net used in the samples is no longer valid. You have to
change all references to the new address www.perfectxml.com. If you
are using Excel 2003, please download this new version of the sample.
- Page 780, Automation and .NET, update: Excel 2003
already includes a PIA (primary interop assembly). If can be installed
with the Excel/Office setup program (component Microsoft Office Excel,
.NET Progammability Support). You might also have a look at this KB
article.
Beginning with .NET 1.1 (Visual Studio 2003), Visual Studio Tools
for Office (VSTO) provide even more comfort and functions for .NET
developers. Unfortunately, VSTO is a product for itself. You need
Visual Studio 2003 and Excel/Office 2003 to use it. (With other words:
it is kind of expensive ...) Finally, some links to VSTO:
VSTO overview
VSTO introduction
Microsoft
developter tools roadmap
VSTO 2005 beta