Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy each control & rename
Not sure why "copy" is not an offered method for controls.
Anyhow, I'm trying to copy and paste a group of images on my userform (destination is not important right now) and have them renamed. Each image name begins with "d1_". I simply need to copy and paste each image - the only thing that will change is that I need replace the first 3 char. of the name (for example, from "d1_7777" to "d2_7777"). Thx. Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy each control & rename
Images are loaded into an image control. They aren't copied and pasted.
Image1.Picture = LoadPicture("C:\Windows\Desktop\hi.bmp") You can build your file name as part of the string argument to LoadPicture -- Regards, Tom Ogilvy "Jason Morin" wrote in message ... Not sure why "copy" is not an offered method for controls. Anyhow, I'm trying to copy and paste a group of images on my userform (destination is not important right now) and have them renamed. Each image name begins with "d1_". I simply need to copy and paste each image - the only thing that will change is that I need replace the first 3 char. of the name (for example, from "d1_7777" to "d2_7777"). Thx. Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro: Copy a worksheet and rename it to a specified value | Excel Discussion (Misc queries) | |||
Copy worksheet and rename sheet | Excel Discussion (Misc queries) | |||
How do you copy and rename linked worksheets? | Excel Discussion (Misc queries) | |||
Copy/Rename a sheet | Links and Linking in Excel | |||
Copy and rename files from hyperlink | Excel Programming |