position of inserted picture files in Excel 2007

M

maple3

I have a problem with pictures that move when I try to publish an excel
worksheet to html.
I have an excel template into which I insert 5 separate picture files to
certain locations by using: -

ActiveSheet.Shapes.AddPicture temp1, False, True, Range("graph1").Left,
Range("graph1").Top, 300, 200

I then publish the template using: -

ActiveWorkbook.PublishObjects.Add(xlSourceRange, temp6, "Template",
"$B$1:$K$103", xlHtmlStatic, htm1, "").Publish (True)

Although the pictures are perfectly positioned before publishing, the output
displaces the pictures slightly so that they our out of position. This also
happens when doing a straightforward copy-pastespecial as bitmap.

The really strange thing is that the pictures also move in the source excel
template after publishing or copying.

I have only had this problem in EXcel 2007. In Excel 2003 it worked fine.

Any ideas?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top