Reply to thread

Message: [QUOTE="RB Smissaert, post: 6117534"] You would make an ActiveX dll. If you compile in VB6 with Global MultiUse than all you have to do is set a reference in Excel to your dll via Tools, References and you can access your functions in the dll directly. You will have to register the dll as well with Windows with Regsvr32, but that can be done quite simply in VBA. So, for example you coded a function in VB6 like this: Function AddUp(lNumber1 as Long, lNumber2 as long) as Long AddUp = lNumber1 + lNumber2 End Function Then you can do in VBA: MsgBox AddUp(1, 2) As simple as that. Note that you can also use VB6 forms in this dll and there are some advantages to that as well. RBS [/QUOTE]