[markd]

Can I know like how to call / run a dll from excel macro.

I have created a custom button and when clicking that button I need the dll to be called and executed. I am new to excel and a good working example would help me a lot.

Pls help.

Thanks,

[Advertisements]

Ok. A little bit improvemnet from my previous post.

what I did was I created a dll called ClassLibrary2.dll which is located in say "c:\\test\...\bin\Debug\" directory.

i declared the below in my Excel: (saw this from one of the post here)

Public Declare Sub Math Lib "C:\test\...\ClassLibrary2.dll" ()

and in the button click event I call

Sub btn_click()
call Math
end sub


I am calling a method which is defined inside the dll. But when I run the macro I get an error messge
"Can not find a dll entry point Math in c:\\test\...\bin\Debug\ClassLibrary2.dll"


I created this dll with c# as below:

using System;

namespace ClassLibrary2
{
public class Class1
{
public void Math()
{
Console.WriteLine("hELLO WORLD");
}
}
}


pls help.

Thanks,

[markd]

Ok. A little bit improvemnet from my previous post.

what I did was I created a dll called ClassLibrary2.dll which is located in say "c:\\test\...\bin\Debug\" directory.

i declared the below in my Excel: (saw this from one of the post here)

Public Declare Sub Math Lib "C:\test\...\ClassLibrary2.dll" ()

and in the button click event I call

Sub btn_click()
call Math
end sub


I am calling a method which is defined inside the dll. But when I run the macro I get an error messge
"Can not find a dll entry point Math in c:\\test\...\bin\Debug\ClassLibrary2.dll"


I created this dll with c# as below:

using System;

namespace ClassLibrary2
{
public class Class1
{
public void Math()
{
Console.WriteLine("hELLO WORLD");
}
}
}


pls help.

Thanks,