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
Category Archives: Excel
Excel UDF absolute path problem and #NAME! error
1 Reply
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
Excel Text-Property of a Range Object
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