Hi, can somebody help me?
I have a macro inserting pictures from a local folder. Once the picture is
inserted I scale it and move it to a cell. It worked perfect with Excel 2003
but it doesn't work very well with excel 2007.
I assign to the picture the same coordinate than the cell where I can put it:

Picture.Top = Cell.Top
Picture.Left = Cell.Top

On excel 2007 the picture moves upwards, and if the pictures are many, the
last ones moves very much away from the cell. Even when I check the values
of the picture and cell and those values match exactly.

Please give me a clue where to look into.

thank you

"Russ" wrote:

It's been awhile since I looked at the code and I am away from office until
next week. If you send me the code I will take a look next week when I get
home.
Russ
--
russ


"dickiebird" wrote:

Russ
I have a similar problem. With excel 2003 my macro inserted a picture into
a report at a range selected in the macro. In excel 2007 the macro always
inserts the picture in the top left part of the worksheet. It ignores the
range selected. With multiple pictures inserts in a nujmber of macros which
run as a set, many pictures pile up on top of each other.
When a picture is inserted manually, it appears where the cell pointer is
located.
Any ideas on how to fix the code - which I can provide if necessary.
dickiebird



"Russ" wrote:

I have found that Excel 2007 inserts pictures in a different way than Excel
2003. I noticed that Ron de Bruin commented in the thread €œhow to add
pictures to worksheet from url in Excel 2007€� of a possible bug in Excel
which may relate to what I found.
In Excel 2003 if you do
Activesheet.Pictures.Insert (filename)
The picture will be inserted in the upper left hand corner of the cell that
is selected.
In Excel 2007 the picture is inserted at a location that is independent of
the selected cell. Has anyone else encountered this problem?
Russ

--
russ