You need some basic objects to create Excel XLL Add-Ins with Delphi. At first, we need a structure to exchange data with Excel. Therefore, Microsoft describes the XLOPER and XLOPER12 structures inside the Excel Software Development Kit (SDK). Continue reading
What kind of relationship exists between Delphi and Excel? Delphi is seldom associated with Microsoft Excel. And some people spread the rumor that Managed Code is the best practice for Excel Add-Ons. But it is baseless. Microsoft provides a C-API. And in the old days of Visual Studio 6, VB was a good choice too. Continue reading
The language reference describes a typical application of the ChangeLink method. This article describes another useful application. There is a special kind of workbooks that also generate links – VBA Add-Ins. Continue reading
VBA Add-Ins (XLA, XLAM) that provide User Defined Functions (UDF) are an easy way to add functionality to Microsoft Excel. But a typical problem with such add-ins result from the way Excel stores function calls in a workbook. Your UDFs work fine as long as the path to the addin does not change. Continue reading
Don’t be confused if you look at the official documentation. The Text Property of an Excel Range Object is a read-only string. It returns or sets the text for the Range Object. This is a real concise description, isn’t it? Continue reading
Mygla (Μύγλα) was a goddess in the Greek mythology. A well-known part of the Greek mythology is Hesiod’s Theogony with the Twelve Olympians. Other parts got lost in the course of time. Continue reading
Sometimes, you find a glade when you walk through a forest, a glade with a big tree that invites you to sit down under its shade and to enjoy such a nice place. Continue reading