Re: Repost: Speed of inserting pictures and Excel memory

Hi Juan Pablo,

Yes I'm sure that would be a possibility, lots of code though!

I've been meaning to look more into the IPicture object for other reasons,
eg to make low res' / memory thumbnails.

Currently I store the original dimensions just after Insert.Picture, before
resizing.

Regards,
Peter T

"Juan Pablo González" <JuanPablo@xxxxxxxxxxx> wrote in message
news:OXwBkfnuFHA.1256@xxxxxxxxxxxxxxxxxxxxxxx
> Not directly that I know of, but I think you can get the image properties
by
> loading it into a IPicture object, if I remember correctly (I think I did
> something like that a while ago, can't remember for sure now)
>
> --
> Regards,
>
> Juan Pablo González
> Excel MVP
>
> "Peter T" <peter_t@discussions> wrote in message
> news:e$K4ifhuFHA.2540@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi Juan Pablo,
> >
> > I never thought to use the Reset button in Format Picture / Size, for
the
> > purpose you describe. Good idea.
> >
> > The same dialog indicates original Height & Width. Seems strange that
VBA
> > does not expose these properties directly, or does it ?
> >
> > Regards,
> > Peter T
> >
> > "Juan Pablo González" <JuanPablo@xxxxxxxxxxx> wrote in message
> > news:u3ZnW6auFHA.460@xxxxxxxxxxxxxxxxxxxxxxx
> >> Greg,
> >>
> >> You are correct about the Shapes.AddPicture, it is a pain. However, it
> >> is
> >> simply "fixable". If you record a macro that selects a shape, and
reset
> > it
> >> to its default state, you'll have the required lines to resize the
shape
> > to
> >> its original size without distorting it.
> >>
> >> I had to switch from the Pictures.Insert because it was failing for no
> >> apparent reason that I could see, and so far I haven't had any other
> > issues
> >> with Shapes.AddPicture, besides having to resize the picture after I
> > insert
> >> it.
> >>
> >> --
> >> Regards,
> >>
> >> Juan Pablo González
> >> Excel MVP
<snip>


.