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