CODEWITHSUNDEEP
excelvbadll
KJ Saxena
KJ Saxena

Reputation: 21828

Accessing DLLs through VBA

How can I access the functions inside a third-party DLL from VBA (Excel)? Also, is there a way to see what all functions are available inside a DLL?

Upvotes: 10

Views: 16206

Answers (1)

Justin
Justin

Reputation: 6711

To call a function in a third-party DLL, you need to use the Declare statement. For example:

Private Declare Function GetTempPath Lib "kernel32" _
     Alias "GetTempPathA" (ByVal nBufferLength As Long, _
     ByVal lpBuffer As String) As Long

See How to: Access DLLs in Excel on MSDN for more information.

To list the functions that are available, take a look at the Dependency Walker tool, which will list the exported functions from DLLs (and lots of other information).

Upvotes: 9

Related Questions