Steema Central

I hadn't used TeeChart Pro ActiveX v5 for some time, and I must have changed some things in my setup (windows 2000). Now, if I insert a TeeChart on a form from, say excel, I can't get the chart editor to come up. If I right click on the empty graph, I don't get the menu with the "edit" command (or anything mentioning teechart). I tried uninstalling TeeChart, downloading a new copy of TeeChart Pro Activex v5, installed that, but still no joy.

Can you suggest how to get this set up properly again.

thanks
Robert

Hi Robert,

do the examples included in the TeeChart Pro v5 installation under :
C:\Program Files\TeeChart Pro v5 ActiveX Control\Examples\VBA Excel 2000\
work fine for you ?

yes and no. The first example, with a static image, works fine. The
second, "TeeChart Pro Inserted into Excel2000.xls" give me this error:
compile error: can't find project or library at the line containing TChart1.AddSeries (scBar)

But I can click on the image on the excel page to pull up the chart editor.

Robert

Hi Robert,

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).

I have found the copies that are made, on my computer they are stored in c:\TEMP\Excel8.0\TeeChart.exd for example. I have tried removing these, re opening excel, placing a teechart object on a form and they get recreated. But the problem persists. Can you suggest any other approaches to get this going again. I don't really want to reinstall office, but I will if it fixes it.

thanks
Robert

Hi Robert,

.. make sure you've removed all the .exd files (teechart files). I the problem persists I can only suggest you try to uninstall and install again the office.

Hi Pep and Robert,

I'm having the same issue, having just installed ActiveX 6.0.0.6 and the update.

The first example, with a static image, works fine. The
second, "TeeChart Pro Inserted into Excel2000.xls" gives me the same error:
compile error: can't find project or library at the line containing TChart1.AddSeries (scBar).

I've tried deleting the .exd file and searched my entire hard drive for any hidden copies, but the problem still persists. I don't see that reinstalling office will help, as I've just installed TeeChart for the first time.

The problem seems to be that for some reason Excel thinks it's using TeeChart Pro Activex Control and TeeChart Pro Activex Control v5 as references, both of which are marked in the Tools>References... dialog box in excel code editor as "MISSING"...which they clearly are as I don't have version 5 installed. The reference TeeChart Pro Activex Control v6 is listed below and has been found, as would be expected. The problem surely is...if these references each have copies of the TeeChart objects, I need to delete the v5 references. However, I can't deselect them in the dialog box as they are claiming to be in use. Anyone any suggestions?

Many thanks.

Phil.

Hi Phil,

try to restart your system and remove the references before try to use them. Make sure you don't have any teechart5.ocx installed or registered (in the registry), if so remove them, then do a seach for all the .exd which reference to TeeChart. The TeeChart Pro v5 should not appear in the reference list.

Hi,

There were no TeeChart5 references in my registry or anywhere else. The example spreadsheet will at no point allow me to deselect the v5 references that it can't find. I guess this is just a bug in the spreadsheet? I have got around it by copying the code to a new spreadsheet with the right references setup.

However, new, more serious problem is that Excel crashes every time I try to add a TeeChart control to my userform. See thread...http://www.teechart.net/support/viewtopic.php?t=2715.

Thanks,
Phil.

Hi Phil,

Can you please try with v6.0.0.7 as I told in your other message?

Thanks in advance.