How do I access/call an Excel Add-in function from Visual Basic 6
C Chip Pearson Jan 21, 2004 #2 Alan, You can use the Application.Run method. E.g,. XL.Run "AddinFileName.xla!MacroName" where XL is your reference to the Excel application. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Alan, You can use the Application.Run method. E.g,. XL.Run "AddinFileName.xla!MacroName" where XL is your reference to the Excel application. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
