Yesteday, I was working on using some external dll to run with excel macros. Although it took a couple hours for googling, it is quite straight forward..
Declare Function Ding Lib "Project1.dll" Alias "HelloWorld" _
() As Integer
Dim a As Integer
a = Ding()