Using ActiveX in VBA crashes Excel

Jurgen · Post by **Jurgen** » Wed Aug 17, 2005 10:36 am

Hello,

We build an Excel tool for one of our clients using TeeChart ActiveX v6.0.0.4
they reinstalled the workstation on which the tool was running, and reinstalled the ActiveX. As from that moment on, Excel crashes when they try to access the ActiveX with VBA code. What does work:
We can put the control directly on a sheet.
We can NOT open the VBA project anymore without crashing Excel.
We CAN NOT run the macro that accesses through VBA an ActiveX dropped on a userform.
Any ideas what could be wrong?

regards,

Jurgen De Bruyne

Narcís · Post by **Narcís** » Wed Aug 17, 2005 11:00 am

Hi Jurgen,

Have you tried if the Excel examples shipped with TeeChart Pro ActiveX work on that machine?

Could you please send us an example we can run "as-is" to reproduce the problem here?

You can post your files at [url]news://www.steema.net/steema.public.attachments[/url] newsgroup.

Jurgen · Post by **Jurgen** » Wed Aug 17, 2005 11:09 am

Hi,
The Excel VBA samples don't work either.
I'll post a very simple example that doesn't work on the mentioned workstation, but does work on others. Thanks for looking at the problem

Jurgen

Narcís · Post by **Narcís** » Thu Aug 18, 2005 6:57 am

Hi Jurgen,

The problem may lie with VBA's access method to ocxs. I'm not aware of
how that might relate to the particular VBA application that you are working with but applications in Microsoft Office that use VBA to access
ocx controls make a copy of the type library of the control (eg. in Excel they make .exd extension files. Typical location:

C:\Documents and Settings\YourUserName\Local Settings\Temp\Excel8.0

We have encountered version control problems in the past with these files (don't update with new versions). I don't say that for sure that the problem lies here but there may be a file handle issue related to this and VBA's access to these files and/or the ocx, for example perhaps tying up excessive file handles (and therefore releasing them when the app is closed and restarted).

Jurgen · Post by **Jurgen** » Fri Aug 19, 2005 12:18 pm

Hi Narcis,

Thanks for helping on the problem.
We are trying this out at the moment: uninstall the latest version (6.0.0.6). Deleting the 'TeeChart.exd' files, and installing the version 6.0.0.4 or 6.0.0.5 again. I'll let you now the results.

regards, Jurgen

Jurgen · Post by **Jurgen** » Mon Aug 22, 2005 8:35 am

Hi,

I wanted to confirm that the above procedure (going back to 6.0.0.5) got our tool back running.
Thanks,

Jurgen

PhilOutram · Post by **PhilOutram** » Thu Oct 12, 2006 3:02 am

Hi,

I'm hitting exactly the same problem that Jurgen was - Excel crashes whenever I try to add a TeeChart control to a userform. I've only installed version 6.0.0.6 and don't have access to version 6.0.0.5. The first excel example works fine, but the second doesn't. See the http://www.teechart.net/support/viewtop ... hlight=vba topic. I've got around this problem by copying the code into a new spreadsheet.

However, now I desperately need to create TeeChart objects in my userforms. Jurgen got around this by uninstalling v6.0.0.6 and reinstalling v6.0.0.5. However, I don't have this version. Any ideas?

Thanks,
Phil.

Narcís · Post by **Narcís** » Fri Oct 13, 2006 10:08 am

Hi Phil,

This problem is fixed in v6.0.0.7 which is available as an update build in the client area. Can you please test if this version works fine for you?

PhilOutram · Post by **PhilOutram** » Sun Oct 15, 2006 10:14 pm

Hi,

Unfortunatley downloading and installing the update build... TeeChartAX6UpdateBuild.exe
...does not fix the problem - which is that Excel crashes as soon as I add a TeeChart control and try to put it on a userform.

Bizarrely when I click on a chart control in one of the Excel examples, the About Teechart dialog reports that the version installed is 6.0.1.1 - not the 6.0.0.7 I am expecting (before installing the upgrade, it was definitely version 6.0.0.6). Additionally, this upgraded version is not in English - is there an English version of 6.0.0.7?

Any further suggestions would be much appreciated.

Thanks,
Phil.

PhilOutram · Post by **PhilOutram** » Wed Oct 25, 2006 2:32 am

Hi guys,

Any thoughts on this (i.e. the above)?

Thanks,
Phil.

Narcís · Post by **Narcís** » Wed Oct 25, 2006 9:15 am

Hi Phil,

For now the only solution is to keep using v6.05. We will let you know if we can release a new version with this problem solved.

I'll send you a private message with the URL where you can download v6.05 from.

PhilOutram · Post by **PhilOutram** » Wed Oct 25, 2006 9:52 pm

Thanks and looking forward to receiving it

Narcís · Post by **Narcís** » Thu Oct 26, 2006 7:36 am

Hi Phil,

Haven't you received a forums private message? You should find it at the top of the forums page, under FAQ, Search, Usergroups, ... links. If you don't receive it please let me know and I'll send it to your forums contact e-mail address.