Error 430 in XLS file using ActiveX EXE
 

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?

Error 430 in XLS file using ActiveX EXE
 

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

Error 430 in XLS file using ActiveX EXE
 

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" wrote:

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

Error 430 in XLS file using ActiveX EXE
 

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!

Error 430 in XLS file using ActiveX EXE
 

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