insert picture problem

[kidev]

How can I insert the same picture into several worksheets:
* without using the clipboard; and
* without re-loading the same file repeatedly; and
* re-sizing the picture to fit within a designated range.

I am currently using the pictures collection on each
sheet like this:
Dim pic as excel.picture
pic = activesheet.pictures.insert("pic.jpg")
' set pic.height and pic.width to resize
This lets me resize it but I am not sure about the
other two issues.

[Tom Ogilvy]

I think you would have to either copy it and paste or use your insert command
and resize it.



--
Regards,
Tom Ogilvy


"kidev" wrote:

> How can I insert the same picture into several worksheets:
> * without using the clipboard; and
> * without re-loading the same file repeatedly; and
> * re-sizing the picture to fit within a designated range.
>
> I am currently using the pictures collection on each
> sheet like this:
> Dim pic as excel.picture
> pic = activesheet.pictures.insert("pic.jpg")
> ' set pic.height and pic.width to resize
> This lets me resize it but I am not sure about the
> other two issues.
>

[kidev]

Does the insert command use the clipboard?

"Tom Ogilvy" wrote:

> I think you would have to either copy it and paste or use your insert command
> and resize it.
>
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "kidev" wrote:
>
> > How can I insert the same picture into several worksheets:
> > * without using the clipboard; and
> > * without re-loading the same file repeatedly; and
> > * re-sizing the picture to fit within a designated range.
> >
> > I am currently using the pictures collection on each
> > sheet like this:
> > Dim pic as excel.picture
> > pic = activesheet.pictures.insert("pic.jpg")
> > ' set pic.height and pic.width to resize
> > This lets me resize it but I am not sure about the
> > other two issues.
> >

[Tom Ogilvy]

No.

--
Regards,
Tom Ogilvy

"kidev" <kidev@newsgroups.nospam> wrote in message
news:7F86EDE3-DA46-45E1-B187-62988CA1BF4D@microsoft.com...
> Does the insert command use the clipboard?
>
> "Tom Ogilvy" wrote:
>
> > I think you would have to either copy it and paste or use your insert
command
> > and resize it.
> >
> >
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "kidev" wrote:
> >
> > > How can I insert the same picture into several worksheets:
> > > * without using the clipboard; and
> > > * without re-loading the same file repeatedly; and
> > > * re-sizing the picture to fit within a designated range.
> > >
> > > I am currently using the pictures collection on each
> > > sheet like this:
> > > Dim pic as excel.picture
> > > pic = activesheet.pictures.insert("pic.jpg")
> > > ' set pic.height and pic.width to resize
> > > This lets me resize it but I am not sure about the
> > > other two issues.
> > >