Re: Using a dll in vba

You cannot create normal Windows DLLs in Visual Basic. You can
create ActiveX DLLs. You can then call them with code like

Dim MyObject As DLLProjectName.MyObjectClass
Set MyObject = New DLLProjectName.MyObjectClass
MyObject.ProcedureName

You'll need to set a reference to the DLLProjectName. In VBA, go
to the Tools menu, choose References, and select your
DLLProjectName from the list.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com







"David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B4717815-A0C5-4480-8BAC-3A008C95EDA6@xxxxxxxxxxxxxxxx
I created a dll in vb 5. I am trying to use the dll in a
spread*** but I am
getting the runtime error 453 "Can't find DLL entry Point"
(using excel 2000)

I have the following code in a module:
Declare Sub cleanup Lib "f:\final inspection\master
templates\final_inspection" ()

I have the following code in a button on the ***:
Sub cmdcleanup_Click()
cleanup
End Sub

The sub cleanup is public in the dll and I have also created
referances in
the workbook to the dll.

David




.