pshp

  1. L

    VBA URLPictureInsert pics disappear

    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...
  2. S

    Insert Image from URL - Save Image with Workbook

    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! :)...
  3. DataBlake

    Troubleshooting Loop In PictureInsert Code

    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 = ""...
  4. DataBlake

    Speeding up image inserts [vba]

    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 =...
  5. DataBlake

    Using URLs to Insert Pictures [VBA]

    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...
  6. D

    How to insert (filenam) as PNG

    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...
  7. N

    Excel VBA - How to extract the image from url and embed in excel?

    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...
  8. T

    Saving images from urls within excel to a directory instead of excel sheet.

    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...
  9. L

    Macro runs when workbook opens

    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...
  10. S

    Inserting picture from a dynamic URL in a cell

    ​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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top