Error 430 in XLS file using ActiveX EXE

[karlww]

I recently upgraded an ActiveX EXE built in VB6 that is used by a few Excel
spreadsheets. I preserved binary compatibility when I compiled the project.

I can use the ActiveX EXE without any problems (it queries our database)
except in some cases where an existing spreadsheet that has a reference to it
set when the old version of the EXE was around. We found one old XLS that
didn't have a problem with the new EXE (which it shouldn't since the binary
compatibility was preserved). But others give the error 430, which seems to
go away if I drop the reference to the EXE, close and save the XLS, then
re-open it an restore the reference.

Is this a bug in Excel (version 2003)? Why would any XLS which is using a
binary compatible ActiveX EXE complain but others would not? Is Excel
caching something it shouldn't?

 

[Ben McBen]

Sounds like it could be GUID related, let me have a dig around and come back
to you...

 

[karlww]

Thank you, I appreciate it.
FWIW, I did check the registry on user's PC that was having an issue with
mine. The CLSID's were identical.

 

[Ben McBen]

Oh deep joy! (not...)

Can I recomend a leaf through:

http://www.vbsight.com/BinaryComp.htm

It was a long time ago I had similar issues, and I think this is the page
that got me out of my hole.

Best of luck - get coffee in now!

 

[karlww]

I did find that the "Forward" key changed. From the VBR files....

==========
OLD
==========
HKEY_CLASSES_ROOT\INTERFACE\{F4963AD7-3A31-11D3-94AE-00104BD267EE} = AutoQuery
HKEY_CLASSES_ROOT\INTERFACE\{F4963AD7-3A31-11D3-94AE-00104BD267EE}\ProxyStubClsid = {00020420-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\INTERFACE\{F4963AD7-3A31-11D3-94AE-00104BD267EE}\ProxyStubClsid32 = {00020420-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\INTERFACE\{F4963AD7-3A31-11D3-94AE-00104BD267EE}\Forward =
{14D6EF10-B00E-4437-B29B-FA5ED0D09481}
HKEY_CLASSES_ROOT\INTERFACE\{14D6EF10-B00E-4437-B29B-FA5ED0D09481} = AutoQuery
HKEY_CLASSES_ROOT\INTERFACE\{14D6EF10-B00E-4437-B29B-FA5ED0D09481}\ProxyStubClsid = {00020420-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\INTERFACE\{14D6EF10-B00E-4437-B29B-FA5ED0D09481}\ProxyStubClsid32 = {00020420-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\INTERFACE\{14D6EF10-B00E-4437-B29B-FA5ED0D09481}\Typelib =
{AD44705A-086C-11D3-94A6-00104BD267EE}
HKEY_CLASSES_ROOT\INTERFACE\{14D6EF10-B00E-4437-B29B-FA5ED0D09481}\Typelib\"version" = 5.2

==========
NEW
==========
HKEY_CLASSES_ROOT\INTERFACE\{F4963AD7-3A31-11D3-94AE-00104BD267EE} = AutoQuery
HKEY_CLASSES_ROOT\INTERFACE\{F4963AD7-3A31-11D3-94AE-00104BD267EE}\ProxyStubClsid = {00020420-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\INTERFACE\{F4963AD7-3A31-11D3-94AE-00104BD267EE}\ProxyStubClsid32 = {00020420-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\INTERFACE\{F4963AD7-3A31-11D3-94AE-00104BD267EE}\Forward =
{68C0AC0E-70EE-42E9-842A-33F776ECA6CC}
HKEY_CLASSES_ROOT\INTERFACE\{68C0AC0E-70EE-42E9-842A-33F776ECA6CC} = AutoQuery
HKEY_CLASSES_ROOT\INTERFACE\{68C0AC0E-70EE-42E9-842A-33F776ECA6CC}\ProxyStubClsid = {00020420-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\INTERFACE\{68C0AC0E-70EE-42E9-842A-33F776ECA6CC}\ProxyStubClsid32 = {00020420-0000-0000-C000-000000000046}
HKEY_CLASSES_ROOT\INTERFACE\{68C0AC0E-70EE-42E9-842A-33F776ECA6CC}\Typelib =
{AD44705A-086C-11D3-94A6-00104BD267EE}
HKEY_CLASSES_ROOT\INTERFACE\{68C0AC0E-70EE-42E9-842A-33F776ECA6CC}\Typelib\"version" = 5.2