Error in loading DLL

[Guest]

I am stumped. I'm using XL 2002 and Windows 2000

I wrote two ActiveX DLLs in VB 6.0 and have selected them in the References list in the Tools/References. dialog

Each DLL references the Excel 10.0 library, as well as other libraries. (I can include these if it would be helpful)

When I enter a value in a cell, and either press the Enter key or use the arrows to navigate to another cell, I get a 'Error in loading DLL' message. If I delete a value from a cell, I don't get the message. If I select a cell and type a name in the Names box, I get the 'Error in loading DLL' message

Does anyone understand this. I suspect that Excel is doing something under the sheets that I don't know about

Any help would be greatly appreciated

Joe

 

[Holger Gerths]

Hi,

check the registration of your DLLs in the registry. If you have multiple
versions under the typelib GUID, you have
COM problems. Best way is to unregister DLLs, remove all registry entries
manually, register again and re-reference in Excel again.


Any idea how I can determine exact datapoint positions in stacked column
charts? I can only get the Left prop of Datalabel.

I am stumped. I'm using XL 2002 and Windows 2000.

I wrote two ActiveX DLLs in VB 6.0 and have selected them in the

References list in the Tools/References. dialog.

Each DLL references the Excel 10.0 library, as well as other libraries.

(I can include these if it would be helpful).

When I enter a value in a cell, and either press the Enter key or use the

arrows to navigate to another cell, I get a 'Error in loading DLL' message.
If I delete a value from a cell, I don't get the message. If I select a
cell and type a name in the Names box, I get the 'Error in loading DLL'
message.

Does anyone understand this. I suspect that Excel is doing something

under the sheets that I don't know about.

 

[Guest]

I tried this and I still have the same problem

Any other ideas

Thanks

Jo

----- Holger Gerths wrote: ----

Hi

check the registration of your DLLs in the registry. If you have multipl
versions under the typelib GUID, you hav
COM problems. Best way is to unregister DLLs, remove all registry entrie
manually, register again and re-reference in Excel again


Any idea how I can determine exact datapoint positions in stacked colum
charts? I can only get the Left prop of Datalabel

I am stumped. I'm using XL 2002 and Windows 2000

arrows to navigate to another cell, I get a 'Error in loading DLL' message
If I delete a value from a cell, I don't get the message. If I select
cell and type a name in the Names box, I get the 'Error in loading DLL
message