accessing XLL functions from VBA

Add-in Express™ Support Service
That's what is more important than anything else

accessing XLL functions from VBA
 
Ben McKenzie




Posts: 66
Joined: 2010-05-06
I have some functions that I have published in an XLL addin that I want to use from VBA, but they keep coming back saying "Sub or Function not defined". Is there something I need to do to make the XLL functions visible to VBA?
Posted 03 Aug, 2010 10:50:34 Top
Andrei Smolin


Add-in Express team


Posts: 14114
Joined: 2006-05-11
Hi Ben,

There's no way to make those functions visible for VBA. You can use ExcelApp.Evaluate to access the functions.

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 03 Aug, 2010 11:39:21 Top