C#.net dll in VBA
Posted Date Unknown Jobi John 5 Comments

How to use C#.net dll in VBA? I wanted to do that with out registering it. I will put the dll in some folder and will give the path in the excel, and then I need to run this dll from the VBA code. I was able to get the dll but was not getting the method.

See All Responses Below...
Message Rating
Posted on: 04/02/2014
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

Posted on: 05/02/2014
Using kernel32 or Shell we can able to get the dll in VBA?
Share this page across other social networking sites

Posted on: 05/02/2014
Is there an export from the kernel or shell API that allows the execution of managed code?
Posted on: 05/02/2014
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..

Share this page across other social networking sites

Posted on: 05/02/2014
I mean ATL Wizard..

see this tutorial..


Please Login to Post Your Comments
Name (Max. 100 characters)
Please post your comments here
Select Language
Attach File(Max. Size: 2 MB)
A few simple rules when posting your Comments,
  1. Please post only answers relevant to the topic of discussion.
  2. Please dont misuse this site or do not be abusive, offensive, inappropriate,harass anyone on the boards or post ads or spam. Doing so will delete your inappropriate messages and will block or delete your account on this site. 

Academic Projects