Excel-DNA - UDF Argument Types from VBA to .NET

preview_player
Показать описание
Excel-DNA is the toolkit for making Excel add-ins with .NET.
What types of values appear on Excel worksheets, and how they are passed as arguments to user-defined functions? How do Variant parameters in VBA compare with Object parameters in .NET, when interacting with Excel?

Other useful links:
Рекомендации по теме
Комментарии
Автор

Thank you for this video. Very educational and useful - definitely helps a newbie trying their hand at moving functions form VBA to DNA :-)
Than you again Govert - much appreciated.

dvof
Автор

In the intervening 9 months: I think there's now a new data type, namely "object" - where you can essentially use dot notation on the underlying return value from a formula to access individual properties of it. No idea how those display though / work wrt DNA - topic for another video?

tobyjacobs
welcome to shbcf.ru