| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserted picture name
Hello
I have inserted a small version of a picture onto a spreadsheet. I've then linked a macro that opens a userform with a frame on it that displays a bigger version of the picture when you click on it. This works if I physically put the path name of the picture in the code. Can I pick up in the code the name of the picture on the spreadsheet as I am going to have multiple small pictures on the spreadsheet and would like to only access one sub to load it onto the userform. Regards DaveJones |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserted picture name
I don't believe this information is available as there is no link from the
picture to the file once it is inserted. However, you could just hardcode the reference to the file in your code. -- Regards, Tom Ogilvy "DaveJones" wrote in message ... Hello I have inserted a small version of a picture onto a spreadsheet. I've then linked a macro that opens a userform with a frame on it that displays a bigger version of the picture when you click on it. This works if I physically put the path name of the picture in the code. Can I pick up in the code the name of the picture on the spreadsheet as I am going to have multiple small pictures on the spreadsheet and would like to only access one sub to load it onto the userform. Regards DaveJones |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserted picture name
Tom
What I was trying to do was pick up the name of the picture on the spreadsheet as it appears in the namebox ie "Picture1" and then use this name to load the picture onto the userform. So I would name the files on my hard drive Picture1 etc and then use this variable in the code ie loadpicture("c:\+Picture1+".jpg") or something similar. So I wouildn't need to know the original name.Any ideas?! Regards DaveJones "Tom Ogilvy" wrote: I don't believe this information is available as there is no link from the picture to the file once it is inserted. However, you could just hardcode the reference to the file in your code. -- Regards, Tom Ogilvy "DaveJones" wrote in message ... Hello I have inserted a small version of a picture onto a spreadsheet. I've then linked a macro that opens a userform with a frame on it that displays a bigger version of the picture when you click on it. This works if I physically put the path name of the picture in the code. Can I pick up in the code the name of the picture on the spreadsheet as I am going to have multiple small pictures on the spreadsheet and would like to only access one sub to load it onto the userform. Regards DaveJones |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserted picture name
Maybe you could store the fullpath of the bigger version in the
AlternativeText property of the small worksheet picture. In the macro sPath = ActiveSheet.Shapes(Application.Caller).Alternative Text Simplest is if sPath is a public variable to be read during the forms initialize event, though there are other ways without using a public var. Regards, Peter T "DaveJones" wrote in message ... Hello I have inserted a small version of a picture onto a spreadsheet. I've then linked a macro that opens a userform with a frame on it that displays a bigger version of the picture when you click on it. This works if I physically put the path name of the picture in the code. Can I pick up in the code the name of the picture on the spreadsheet as I am going to have multiple small pictures on the spreadsheet and would like to only access one sub to load it onto the userform. Regards DaveJones |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserted picture name
You can get that in the code fired by the pictu
sName = Application.Caller sStr = "C:\" & sName & ".jpg" -- Regards, Tom Ogilvy "DaveJones" wrote in message ... Tom What I was trying to do was pick up the name of the picture on the spreadsheet as it appears in the namebox ie "Picture1" and then use this name to load the picture onto the userform. So I would name the files on my hard drive Picture1 etc and then use this variable in the code ie loadpicture("c:\+Picture1+".jpg") or something similar. So I wouildn't need to know the original name.Any ideas?! Regards DaveJones "Tom Ogilvy" wrote: I don't believe this information is available as there is no link from the picture to the file once it is inserted. However, you could just hardcode the reference to the file in your code. -- Regards, Tom Ogilvy "DaveJones" wrote in message ... Hello I have inserted a small version of a picture onto a spreadsheet. I've then linked a macro that opens a userform with a frame on it that displays a bigger version of the picture when you click on it. This works if I physically put the path name of the picture in the code. Can I pick up in the code the name of the picture on the spreadsheet as I am going to have multiple small pictures on the spreadsheet and would like to only access one sub to load it onto the userform. Regards DaveJones |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserted picture name
Thanks Peter
I used sPath = ActiveSheet.Shapes(Application.Caller).Name This picked up which picture I had clicked on and loaded the relevant picture from the hard disk. All working fine! Regards DaveJones "Peter T" wrote: Maybe you could store the fullpath of the bigger version in the AlternativeText property of the small worksheet picture. In the macro sPath = ActiveSheet.Shapes(Application.Caller).Alternative Text Simplest is if sPath is a public variable to be read during the forms initialize event, though there are other ways without using a public var. Regards, Peter T "DaveJones" wrote in message ... Hello I have inserted a small version of a picture onto a spreadsheet. I've then linked a macro that opens a userform with a frame on it that displays a bigger version of the picture when you click on it. This works if I physically put the path name of the picture in the code. Can I pick up in the code the name of the picture on the spreadsheet as I am going to have multiple small pictures on the spreadsheet and would like to only access one sub to load it onto the userform. Regards DaveJones |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserted picture name
If you only want the name go with the simpler code Tom suggested
s = ActiveSheet.Shapes(Application.Caller).Name s = Application.Caller will both return the same Regards, Peter T "DaveJones" wrote in message ... Thanks Peter I used sPath = ActiveSheet.Shapes(Application.Caller).Name This picked up which picture I had clicked on and loaded the relevant picture from the hard disk. All working fine! Regards DaveJones "Peter T" wrote: Maybe you could store the fullpath of the bigger version in the AlternativeText property of the small worksheet picture. In the macro sPath = ActiveSheet.Shapes(Application.Caller).Alternative Text Simplest is if sPath is a public variable to be read during the forms initialize event, though there are other ways without using a public var. Regards, Peter T "DaveJones" wrote in message ... Hello I have inserted a small version of a picture onto a spreadsheet. I've then linked a macro that opens a userform with a frame on it that displays a bigger version of the picture when you click on it. This works if I physically put the path name of the picture in the code. Can I pick up in the code the name of the picture on the spreadsheet as I am going to have multiple small pictures on the spreadsheet and would like to only access one sub to load it onto the userform. Regards DaveJones |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserted picture name
Thanks All
Easy when you know how! "Peter T" wrote: If you only want the name go with the simpler code Tom suggested s = ActiveSheet.Shapes(Application.Caller).Name s = Application.Caller will both return the same Regards, Peter T "DaveJones" wrote in message ... Thanks Peter I used sPath = ActiveSheet.Shapes(Application.Caller).Name This picked up which picture I had clicked on and loaded the relevant picture from the hard disk. All working fine! Regards DaveJones "Peter T" wrote: Maybe you could store the fullpath of the bigger version in the AlternativeText property of the small worksheet picture. In the macro sPath = ActiveSheet.Shapes(Application.Caller).Alternative Text Simplest is if sPath is a public variable to be read during the forms initialize event, though there are other ways without using a public var. Regards, Peter T "DaveJones" wrote in message ... Hello I have inserted a small version of a picture onto a spreadsheet. I've then linked a macro that opens a userform with a frame on it that displays a bigger version of the picture when you click on it. This works if I physically put the path name of the picture in the code. Can I pick up in the code the name of the picture on the spreadsheet as I am going to have multiple small pictures on the spreadsheet and would like to only access one sub to load it onto the userform. Regards DaveJones |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I associate an inserted picture with its row? | Excel Discussion (Misc queries) | |||
| how do I write over a picture that was inserted in excel? | Excel Discussion (Misc queries) | |||
| Printing the inserted picture | Excel Discussion (Misc queries) | |||
| picture 34 was inserted by excel? | Excel Discussion (Misc queries) | |||
| How to identify an inserted picture within a formula | Excel Discussion (Misc queries) | |||
Linear Mode
