MsoShapeStyleIndex <> Excel Picture Styles

Add-in Express™ Support Service
That's what is more important than anything else

MsoShapeStyleIndex <> Excel Picture Styles
 
Arie Bensimon




Posts: 20
 Joined: 2007-06-05
I'm adding a pic dynamically
with something like
Dim P As Excel.Shape = DistSheet.Shapes.AddPicture(PicFile, True, True, Left, Top, w, h)

Now I've tried all the presets in
P.ShapeStyle = Microsoft.Office.Core.MsoShapeStyleIndex.msoLineStylePreset10

But none of them reflects the Picture styles that are shown in the format picture ribbon.
Whould you happen to know how to access those formats?
Posted 24 Jun, 2007 07:34:01 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Arie.

The fact is that the ShapeStyle property is designed for built-in shapes or WordArt objects. That is why it doesn't work in this case.
As to the Picture Styles, please try to find something in the Excel 2007 help.
http://msdn2.microsoft.com/en-us/library/bb187365.aspx



P.S. We always do our best to answer your forum requests as soon as possible. However, we apply the rule "first in first out" with Premium Support Service subscribers taking priority. Please understand it may take us some time to do research on the issue. Please be assured we will let you know as soon as the best possible solution is found.
Posted 25 Jun, 2007 12:41:28 Top