View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default Create dll file and call it from Excel worksheet or macro

I haven't used vb.net. I've used VB6 to make a DLL, and guess it's
similar. So I will answer from that background. A DLL has one or more
Public objects of which a calling application can make an instance of.
The Public object will have properties and/or methods that can be
used.

For example, here are some lines of code from a project.
Public moCntrl As Calm.Cntrl
Set myCntrl = New Calm.Cntrl

Calm is a DLL. Cntrl is a Public class which has several Public
objects and methods.

To use the DLL In Excel, it will need a reference in the VB Editor
using the menu Tools | References.

Hth,
Merjet