Manipulating an image with from VBA

  • Thread starter Thread starter avi
  • Start date Start date
A

avi

Hello,

I Create a BMP picture from chart or data. I want to combine a
polygone (let say a circle) or superpose another image in the middle
of the picture . Could it be done from VBA ?

Thanks a lot
Avi
 
Avi,
Record a macro whilst you perform your actions. For the alignment (using the
Draw>Align Or Distribute on the Drawing toolbar), I got this:

ActiveSheet.Shapes.Range(Array("Oval 2", "Picture 1")).Select
Selection.ShapeRange.Align msoAlignCenters, False
Selection.ShapeRange.Align msoAlignMiddles, False

although the selection of object in Excel is seldom necessary.

NickHK
 
hello NickHK ,

Thanks. The problem i have is not so much of alignement but of
superposition, that means that the shape should lay on an existing BMP
image and combine to a new BmP image.

Thanks
Avi
 
Avi,
One is create the picture/shape combination with correct alignment etc, then
select all the parts, copy + paste special in the required format, so you
get a single graphic.
Record a macro of doing that.

NickHK
 
Back
Top