insert picture problem
 

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.

insert picture problem
 

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.

insert picture problem
 

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.

insert picture problem
 

No.

--
Regards,
Tom Ogilvy

"kidev" wrote in message
...
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.