pshp

Hi there, I have VBA to insert images from a filepath which is derived from a formula. The images insert just fine and are visible for me but if someone else opens the documents they cannot be seen (all settings are correct). I'm assuming I need to embed the images but cannot quite get the...

Hi All, I have the below code to insert images into my worksheet from a URL; however, it doesn't save the image with the workbook/worksheet - I need the code modified below so that it saves the actual image with the worksheet and displays it if I share the file with someone else. Help! :)...

Sub URLPictureInsert() Dim Pshp As Shape Dim i As Long Dim lastRow As Long Dim urlRng As Range Dim trgtRng As Range lastRow = Range("A" & Rows.Count).End(xlUp).Row For i = 2 To lastRow Set urlRng = Range("B" & i) Set trgtRng = Range("C" & i) If urlRng = ""...

Sub URLPictureInsert() Dim Pshp As Shape Dim i As Long Dim lastRow As Long Dim urlRng As Range Dim trgtRng As Range lastRow = Range("A" & Rows.Count).End(xlUp).Row For i = 2 To lastRow Set urlRng = Range("B" & i) Set trgtRng = Range("C" & i) If urlRng =...

Hello all, So KuTools has this code which i've adapted for my needs, and when i run through the code with F8 I'm unsure of where it messes up. I have 3 columns of image url's (some cells are blank) I set the range to the first column with images which is column B I want it to insert the images...

Hey guys always such great help:) this macro works great i found online except for one flaw, it keeps the filenam as a string so when i go back and reopen the workbook it re-pulls all the filenam links. This ends up crashing the server which some folks are not too happy with me about:mad: Is...

I am trying to extract the image from url and embed in excel 2007. My Excel is simple , it contains 2 columns , Column 1 has the image url and in other column i want the embed the image. i am using the attached code , it is working perfectly fine for first row where i have saved the image from...

I have a list of urls in column A. I would like to use those urls to fetch the corresponding image and save it to a directory, and keep the size of the original image as is on the site. the code I currently have is importing the image into column B, right next to its url. I'd like to have the...

How do I change this code, so that the macro runs when the workbook opens? Sub InsertMap_Click() 'Updateby Extendoffice 20161116 Dim Pshp As Shape Dim xRg As Range Dim xCol As Long On Error Resume Next Application.ScreenUpdating = False Set Rng = ThisWorkbook.Sheets("Executive...

​I've been trying out and testing different codes online but I can't get mine to consistently work. The situation is this: I want to be able to paste in a URL in Cell A1 so that in Cell B2, it will show the downloaded image from the link. The worksheet will be called "URL Report" I'm having...