View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Excel 2010 Charting in Userform - Can't Access OWC11 Control from Toolbox??

shoeless presented the following explanation :
Good people,

I am stumped...

Chronology:
I use VBA to perform many calculations
I store these calculations in Access
I do all this using the VBE from Excel
I retrieve values from Access, and then store them in local arrays
I bind these arrays to ChartSpaces within UserForms
I've done this successfully using OWC11 and Excel 2007 on a 32-bit version
of Vista I've upgraded Windows 7 64-bit and to Office 2010
Immediately I start getting errors :'( about references, and some
additional keywords I need to use for my code to work on a 64-bit I
updated the references/libraries, and modified the code to run in Office
2010 on 64-bit Windows 7 (e.g. adding the PtrSafe keyword to declaration
statements). I can now run calculation routines successfully When I open
up the UserForms, however, the ChartSpaces are missing?? I make sure OWC11
is referenced correctly; I can browse it within the object browser, so
everything seems fine to me... I try to add "additional controls..." to
the toolbox form, but I cannot find the ChartSpace control under the list
of available controls :''(


Can anyone help me out?
If I can just get the ChartSpace control to the toolbox form, then I
can just re-add the required ChartSpaces that my code references...

I have not been able to solve this problem on my own, and I was unable
to find a solution form internet searches. I am at a loss; any help
would be greatly appreciated,
B


What is a ChartSpace control? What library/ocx is it found in? Does
that library/ocx ship with MSO x64 in a 64 bit version?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc