| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Insert Picture question
If I record a macro, it looks like this:
ActiveSheet.Pictures.Insert("C:\Photos\3078.JPG"). Select Obviously, I want to make the "3078.JPG" a variable that I create by selecting a cell from a list of many JPGs. I tried: AAA=Activecell.Value ActiveSheet.Pictures.Insert("C:\Photos\" & AAA I also tried ActiveSheet.Pictures.Insert Filename="C:\Photos\" & AAA Neither worked. I must be getting the syntax wrong. TIA paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Simple Insert Picture question
Paul,
Both of these work for me AAA = ActiveCell.Value ActiveSheet.Pictures.Insert Filename:="C:\Photos\" & AAA AAA = ActiveCell.Value ActiveSheet.Pictures.Insert "C:\Photos\" & AAA Are you sure you are including the .jpg in the cell value? -- HTH Bob Phillips "Paul" wrote in message ... If I record a macro, it looks like this: ActiveSheet.Pictures.Insert("C:\Photos\3078.JPG"). Select Obviously, I want to make the "3078.JPG" a variable that I create by selecting a cell from a list of many JPGs. I tried: AAA=Activecell.Value ActiveSheet.Pictures.Insert("C:\Photos\" & AAA I also tried ActiveSheet.Pictures.Insert Filename="C:\Photos\" & AAA Neither worked. I must be getting the syntax wrong. TIA paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | 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) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| insert picture | Excel Discussion (Misc queries) | |||
Linear Mode
