In order to call any DLL methods form VBA using any scripting language, you need to implement it as a COM Object and should implement IDispatch interface (scripting interface). In C#.NET . There might be articles in the net which will explain how to do this task.
To the best of my knowledge , there no direct way to access methods in a plane DLL
Tom
Using kernel32 or Shell we can able to get the dll in VBA?
Share this page across other social networking sites
Is there an export from the kernel or shell API that allows the execution of managed code?
VBA are designed to work only from within an application like MS Office or ot can at the most access COM enabled DLLs.. It is designed to call dll methods directly.. If you want call an DLL from VBA, create a COM component that call the DLL methods and expose COM method which can becalled form VBA application. Please dont forget to implement the IDispatch Interface. ATL Simple Object Applcation will do the task for you..
Tom
Share this page across other social networking sites