| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Picture | Excel Discussion (Misc queries) | |||
| how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
| insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
| How to insert a picture | Excel Discussion (Misc queries) | |||
| insert picture | Excel Programming | |||
Hybrid Mode
