LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting an ActiveX error on save TheMilkGuy Excel Discussion (Misc queries) 0 January 12th 09 05:35 PM
ActiveX error message Mike Dunk Excel Discussion (Misc queries) 1 November 29th 06 04:35 PM
ActiveX control error - Red Excel Programming 0 October 15th 05 12:30 AM
Error 50290: Error writing to Worksheet while using an ActiveX Control emblair3 Excel Programming 3 February 24th 04 06:03 PM
Raise Error from ActiveX dll to VBA Serge[_2_] Excel Programming 0 September 23rd 03 05:05 PM


All times are GMT +1. The time now is 11:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"