To be accessed directly from the worksheet or from a customized item in the UI, the function or command must first be registered with Excel. It is recommended that you use either of the other two approaches.
This documentation does not cover XLM functions. Through an XLM macro sheet by using the CALL or REGISTER functions.ĭirectly from the worksheet or from a customized item in the user interface (UI). Through a Microsoft Visual Basic for Applications (VBA) code module in which the function or command has been made available using a Declare statement. You can access a DLL function or command in Microsoft Excel in several ways: Applies to: Excel 2013 | Office 2013 | Visual Studio