| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update A Url Image
Dim URL As String
URL = Worksheets("Sheet1").Range("B4").Value Range("C5").Select ActiveSheet.Pictures.Insert(URL).Select Morning, I found the above code on this forum and it works great but I wonder if it can be modifed. I have a spreadhsheet which asks for a Product code, when entered another cell changes (using a vlookup) be the URL image of the product. Using the above code, it displays the URL image which is great. However, when the product code is changes again, it just inserts another picture rather than update the existing one. How can I have an object set to the URL reference so that it can updated everytime the product code is changed. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update A Url Image
Insert the code in a Worksheet_Change module.
That's it ... "SEAN DI''''ANNO" skrev i en meddelelse ... Dim URL As String URL = Worksheets("Sheet1").Range("B4").Value Range("C5").Select ActiveSheet.Pictures.Insert(URL).Select Morning, I found the above code on this forum and it works great but I wonder if it can be modifed. I have a spreadhsheet which asks for a Product code, when entered another cell changes (using a vlookup) be the URL image of the product. Using the above code, it displays the URL image which is great. However, when the product code is changes again, it just inserts another picture rather than update the existing one. How can I have an object set to the URL reference so that it can updated everytime the product code is changed. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update A Url Image
Ups, didn't read your question properly at first - sorry :-)
You'll of casue has to delete the current picture first, before inserting a new one... "Charlotte E." skrev i en meddelelse ... Insert the code in a Worksheet_Change module. That's it ... "SEAN DI''''ANNO" skrev i en meddelelse ... Dim URL As String URL = Worksheets("Sheet1").Range("B4").Value Range("C5").Select ActiveSheet.Pictures.Insert(URL).Select Morning, I found the above code on this forum and it works great but I wonder if it can be modifed. I have a spreadhsheet which asks for a Product code, when entered another cell changes (using a vlookup) be the URL image of the product. Using the above code, it displays the URL image which is great. However, when the product code is changes again, it just inserts another picture rather than update the existing one. How can I have an object set to the URL reference so that it can updated everytime the product code is changed. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update A Url Image
...Which is my problem Charlotte. if the product No is changed several times, a new picture is inserted each time with a new name so I was unsure how to delete teh existing one if there is one. I was trying to have a picture object already and then just update its URL property but don't know how to do this. Can you help? "Charlotte E." wrote: Ups, didn't read your question properly at first - sorry :-) You'll of casue has to delete the current picture first, before inserting a new one... "Charlotte E." skrev i en meddelelse ... Insert the code in a Worksheet_Change module. That's it ... "SEAN DI''''ANNO" skrev i en meddelelse ... Dim URL As String URL = Worksheets("Sheet1").Range("B4").Value Range("C5").Select ActiveSheet.Pictures.Insert(URL).Select Morning, I found the above code on this forum and it works great but I wonder if it can be modifed. I have a spreadhsheet which asks for a Product code, when entered another cell changes (using a vlookup) be the URL image of the product. Using the above code, it displays the URL image which is great. However, when the product code is changes again, it just inserts another picture rather than update the existing one. How can I have an object set to the URL reference so that it can updated everytime the product code is changed. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update A Url Image
Sorry, I'm a little slow today :-)
If you don't have any other pictures, figures or charts on the spreadsheet, the easiest way is just to put... ActiveSheet.DrawingObjects.Delete ....before inserting the picture, so your you have these lines in your code: ActiveSheet.DrawingObjects.Delete ActiveSheet.Pictures.Insert(URL).Select BR, "SEAN DI''''ANNO" skrev i en meddelelse ... ..Which is my problem Charlotte. if the product No is changed several times, a new picture is inserted each time with a new name so I was unsure how to delete teh existing one if there is one. I was trying to have a picture object already and then just update its URL property but don't know how to do this. Can you help? "Charlotte E." wrote: Ups, didn't read your question properly at first - sorry :-) You'll of casue has to delete the current picture first, before inserting a new one... "Charlotte E." skrev i en meddelelse ... Insert the code in a Worksheet_Change module. That's it ... "SEAN DI''''ANNO" skrev i en meddelelse ... Dim URL As String URL = Worksheets("Sheet1").Range("B4").Value Range("C5").Select ActiveSheet.Pictures.Insert(URL).Select Morning, I found the above code on this forum and it works great but I wonder if it can be modifed. I have a spreadhsheet which asks for a Product code, when entered another cell changes (using a vlookup) be the URL image of the product. Using the above code, it displays the URL image which is great. However, when the product code is changes again, it just inserts another picture rather than update the existing one. How can I have an object set to the URL reference so that it can updated everytime the product code is changed. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update A Url Image
Thats great Charlotte and answers my original question. Just one more
question if I may. How do I insert the picture object in a specific position? "Charlotte E." wrote: Sorry, I'm a little slow today :-) If you don't have any other pictures, figures or charts on the spreadsheet, the easiest way is just to put... ActiveSheet.DrawingObjects.Delete ....before inserting the picture, so your you have these lines in your code: ActiveSheet.DrawingObjects.Delete ActiveSheet.Pictures.Insert(URL).Select BR, "SEAN DI''''ANNO" skrev i en meddelelse ... ..Which is my problem Charlotte. if the product No is changed several times, a new picture is inserted each time with a new name so I was unsure how to delete teh existing one if there is one. I was trying to have a picture object already and then just update its URL property but don't know how to do this. Can you help? "Charlotte E." wrote: Ups, didn't read your question properly at first - sorry :-) You'll of casue has to delete the current picture first, before inserting a new one... "Charlotte E." skrev i en meddelelse ... Insert the code in a Worksheet_Change module. That's it ... "SEAN DI''''ANNO" skrev i en meddelelse ... Dim URL As String URL = Worksheets("Sheet1").Range("B4").Value Range("C5").Select ActiveSheet.Pictures.Insert(URL).Select Morning, I found the above code on this forum and it works great but I wonder if it can be modifed. I have a spreadhsheet which asks for a Product code, when entered another cell changes (using a vlookup) be the URL image of the product. Using the above code, it displays the URL image which is great. However, when the product code is changes again, it just inserts another picture rather than update the existing one. How can I have an object set to the URL reference so that it can updated everytime the product code is changed. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update A Url Image
How do I insert the picture object in a specific position?
Not sure what you mean? Don't you do that with... Range("C5").Select ...to select the picture to be inserted into cell C5? Or, what do you mean? CE "SEAN DI''''ANNO" skrev i en meddelelse ... Thats great Charlotte and answers my original question. Just one more question if I may. How do I insert the picture object in a specific position? "Charlotte E." wrote: Sorry, I'm a little slow today :-) If you don't have any other pictures, figures or charts on the spreadsheet, the easiest way is just to put... ActiveSheet.DrawingObjects.Delete ....before inserting the picture, so your you have these lines in your code: ActiveSheet.DrawingObjects.Delete ActiveSheet.Pictures.Insert(URL).Select BR, "SEAN DI''''ANNO" skrev i en meddelelse ... ..Which is my problem Charlotte. if the product No is changed several times, a new picture is inserted each time with a new name so I was unsure how to delete teh existing one if there is one. I was trying to have a picture object already and then just update its URL property but don't know how to do this. Can you help? "Charlotte E." wrote: Ups, didn't read your question properly at first - sorry :-) You'll of casue has to delete the current picture first, before inserting a new one... "Charlotte E." skrev i en meddelelse ... Insert the code in a Worksheet_Change module. That's it ... "SEAN DI''''ANNO" skrev i en meddelelse ... Dim URL As String URL = Worksheets("Sheet1").Range("B4").Value Range("C5").Select ActiveSheet.Pictures.Insert(URL).Select Morning, I found the above code on this forum and it works great but I wonder if it can be modifed. I have a spreadhsheet which asks for a Product code, when entered another cell changes (using a vlookup) be the URL image of the product. Using the above code, it displays the URL image which is great. However, when the product code is changes again, it just inserts another picture rather than update the existing one. How can I have an object set to the URL reference so that it can updated everytime the product code is changed. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update A Url Image
Thanks Charlotte...Perfect...That was my turn to be stupid.
"Charlotte E." wrote: How do I insert the picture object in a specific position? Not sure what you mean? Don't you do that with... Range("C5").Select ...to select the picture to be inserted into cell C5? Or, what do you mean? CE "SEAN DI''''ANNO" skrev i en meddelelse ... Thats great Charlotte and answers my original question. Just one more question if I may. How do I insert the picture object in a specific position? "Charlotte E." wrote: Sorry, I'm a little slow today :-) If you don't have any other pictures, figures or charts on the spreadsheet, the easiest way is just to put... ActiveSheet.DrawingObjects.Delete ....before inserting the picture, so your you have these lines in your code: ActiveSheet.DrawingObjects.Delete ActiveSheet.Pictures.Insert(URL).Select BR, "SEAN DI''''ANNO" skrev i en meddelelse ... ..Which is my problem Charlotte. if the product No is changed several times, a new picture is inserted each time with a new name so I was unsure how to delete teh existing one if there is one. I was trying to have a picture object already and then just update its URL property but don't know how to do this. Can you help? "Charlotte E." wrote: Ups, didn't read your question properly at first - sorry :-) You'll of casue has to delete the current picture first, before inserting a new one... "Charlotte E." skrev i en meddelelse ... Insert the code in a Worksheet_Change module. That's it ... "SEAN DI''''ANNO" skrev i en meddelelse ... Dim URL As String URL = Worksheets("Sheet1").Range("B4").Value Range("C5").Select ActiveSheet.Pictures.Insert(URL).Select Morning, I found the above code on this forum and it works great but I wonder if it can be modifed. I have a spreadhsheet which asks for a Product code, when entered another cell changes (using a vlookup) be the URL image of the product. Using the above code, it displays the URL image which is great. However, when the product code is changes again, it just inserts another picture rather than update the existing one. How can I have an object set to the URL reference so that it can updated everytime the product code is changed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Andy Pope's button image editor; pasting icons to sheet then toolbar- why does image quality degrade? | Excel Programming | |||
| Image Update Question | Excel Discussion (Misc queries) | |||
| Is there any way to search image of my local drive with Image name or Image Title, Description | Excel Programming | |||
| VBA to display image on a form - image is defined in Range Name | Excel Programming | |||
| Export the worksheet background image as an image file - possible? | Excel Programming | |||
Linear Mode
