I have an application that generates reports displayed in Excel using
VBA code. Our company just upgraded to Office 2007 and MS has changed
the behavior of the AddPicture method so I am trying to convert my
2003 reports over. It used to be that I could just add a picture to a
worksheet and manipulate it after the fact. Now the Shapes.AddPicture
method requires a height and width value; unfortunately, I don't know
the height or width of my picture going in as the pictures are
supplied by the user and can vary in size and h/w ratio. I've been
banging on this trying to figure out how to add the pictures without
specifying a size or barring that, "ask" the picture how big it is but
can't figure that one out either. If someone could point out the
right way to do this I'd appreciate it.