Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I Pass Data to DLLs from Visual Basic for Applications?

April 26, 2017applications Data DLLs pass visual basic

0

Posted

How do I Pass Data to DLLs from Visual Basic for Applications?

1 Answer

0

Posted

Arrays In versions of Microsoft Excel prior to 5.0 arrays were passed to and from DLLs using the XLOPER structure. This structure was quite similar to how arrays were maintained internal to Excel and made quite a bit of sense. When VBA was added to Excel v5.0 a second method of passing array data was introduced. This new method is based upon the OLE 2.0 SafeArray data type. This makes sense when you realize how heavily dependent upon OLE VBA is. The SafeArray data type is allocated using a series of OLE 2.0 functions which all start with SafeArray.