>OK how do I call the macro from Excel?
>

Try the Help Topic Automate a Microsoft Excel task by using an ActiveX control in the Excel Help File. That's exactly what you're looking to do...


>Jim
>
>>>It's a COM Server.
>
>
>>>
>>
>>The reference Evan posted is a good start. You need a VBA macro to instantiate the object and call the appropriate method.
>>
>>>Jim
>>>
>>>>>Does anyone know how to call a dll funtion from Excel?
>>>>>
>>>>
>>>>
>>>>Is the DLL an in-process COM server, or a C-style .DLL?