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...
Author
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

Tom
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..

Tom
Share this page across other social networking sites



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

see this tutorial..

https://www.youtube.com/watch?v=u0IsmKKqXI4

Tom
Please Login to Post Your Comments
Name (Max. 100 characters)
Please post your comments here
Select Language
Comments
   Design  HTML
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. 

TekTipsDownload
GateExam
Academic Projects
TekTipsExperts



 
Site optimized for IE7, 1280 X 768 and above. Copyright © 2010 - 2018 KTS InfoTech
Site Developed Using KTS WebCloud