The reference to an ActiveX DLL is PROJECTNAME.CLASSNAME.

The methods are all public Subs and Functions, and the properties are
Property Let/Get and Variables declared as public.

API declarations and variables declared as Private are NOT exposed.

I am not sure what your CleanUp is going to do but you need to encapsulate
the API in a public SUB (Or Function)

On the machine that created the DLL:

Set MyDLL = CreateObject(project.class) ' substitute as necessary

Sub cmdcleanup_Click()
MyDll.cleanupCF
End Sub

where cleanupCF is the wrapper (Sub or Function) around cleanup.

On other machines, you would need to register the DLL before using it, using
REGSVR32.




"David" wrote:

I created a dll in vb 5. I am trying to use the dll in a spreadsheet 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 sheet:
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