Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference an ole image control's .Picture filename?
I have several ole image controls in a worksheet im working on. I would
like to know the syntax for referring to this object's associated Picture filename (if i load "thisimage.bmp" into the picture property, it works, but when i reference .Picture it displays a long integer value instead of the path/filename im looking for) --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference an ole image control's .Picture filename?
How are you loading the image?
(Just a thought, don't you know the file you used as the source?). -- Regards, Tom Ogilvy bdcrisp wrote in message ... I have several ole image controls in a worksheet im working on. I would like to know the syntax for referring to this object's associated Picture filename (if i load "thisimage.bmp" into the picture property, it works, but when i reference .Picture it displays a long integer value instead of the path/filename im looking for) --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference an ole image control's .Picture filename?
im using this to initially load all the pictures:
sheets(1).myimage.object.picture = _ LoadPicture("path etc .bmp") however, when a user clicks on an image im having this new image 'set' to "clicked image". then, when the use clicks another image, it replaces with the image clicked first.. do yo understand? i would like to say something like: set oldObj = sheets(1).myoldimage previousimage = oldObject.object.picture set newObj = sheets(1).myimage newObj.object.picture = _ LoadPicture(previousimage) however.. here, the value of the previous image's .Picture is a lon integer.. not a path and filename.. i need to reference the image' path and filename for this progra -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference an ole image control's .Picture filename?
Just use something like:
Activesheet.Image3.Picture = Activesheet.Image2.Picture I don't believe there is any link back to the original picture file (this was used by loadpicture, but I don't see any property where it would be retained). -- Regards, Tom Ogilvy bdcrisp wrote in message ... im using this to initially load all the pictures: sheets(1).myimage.object.picture = _ LoadPicture("path etc .bmp") however, when a user clicks on an image im having this new image 'set' to "clicked image". then, when the user clicks another image, it replaces with the image clicked first.. do you understand? i would like to say something like: set oldObj = sheets(1).myoldimage previousimage = oldObject.object.picture set newObj = sheets(1).myimage newObj.object.picture = _ LoadPicture(previousimage) however.. here, the value of the previous image's .Picture is a long integer.. not a path and filename.. i need to reference the image's path and filename for this program --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drawing/image/picture not visible in Excel on one pc | Excel Discussion (Misc queries) | |||
Charts to Image or Picture? | Charts and Charting in Excel | |||
How do I convert a picture (bmp or jpg) to a excel button image? . | Excel Discussion (Misc queries) | |||
userform image from picture in worksheet | Excel Programming | |||
VBA : A picture from http://.../Image.gif | Excel Programming |