Help! Ungrouping Excel Charts --> EMF/WMF. Can't edit objects in 2007 (Freeform issue). Steve Rindsb

[Bob]

Hi, I am posting this again in a hope to get attention to my tricky problem
Bob
_________

Thanks Jon,

Some consolotion, but no solution...


I am not doing any progress at all with this problem. Really need help!(Saw
that Steve had beed in similar thread 1,5 yr ago)

Regarding resulting EMF/WMF shapes, there seems to be a big difference
between seeting the Shape Border to Solid manually compared to doing it
through VBA or through a Chart Style ( I took a standard one).
This is bizarre!

Is there some way to emulate the manual action in the menu?
i.e. something like: Application.Commandbars.Execute ("SolidBorder").

Any other idea?
I have considered parsing the OpenXMLfiles to see what the difference is
between
the files....
How is this done?

Bob

 

[Peter T]

Is this about charts (chartobjects), or about pictures (EMF/WMF inserted
images), or about Freeforms, or all of these.

Is it about ungrouping or is it about changing border styles, or both

Does this concern Excel or Powerpoint or both.

Regards,
Peter T

 

[Bob]

Hi,

This is about disassembling Excel Charts into EMF/WMF objects. Usually done
through the Ungroup command.
It applies to Office 2007. For further understanding, the complete thread is
enclosed.

I have some news!

Previously I discovered that:
- a solid border color is necessary to ungroup the chart shapes into
distinct objects (e.g. rectangles) and not gouped Freeforms
- this works when it is done manually
- making the border solid through VBA ( .border.color = 0) makes the border
appear as solid, but renders Freeforms in the EMF/WMF process! Arghh!!!
- applying styles that have a solid border, doesn't work either...

But,
- If I use a saved template with manually set borders, It works!!!!!!

Isn't this weird!
What is the difference?!

Bob