1. N

    Help easily attaching 100’s pictures or picture URL to spreadsheet

    I would like to start off by saying I know nothing about macros. I was listening to a podcast and the person being interviewed said that he attaches 300-800 scanned images of sports cards to the name of a specific player within a minute or two using macros. Can someone explain this to me? In a...
  2. S

    Show images from worsheets to UserForm

    Hi guys I've got a project but I don't know how to solve this: I want to show an image that already exists in my worksheet using the Image control from UserForm but all the methods that I have seen use the path of the file to insert the image. I can't use this method since I have to share my...
  3. O

    Document Header and Footer images placed in exact locations in bulk

    Hi guys, I'm currently changing the logos in bulk for 1000s of documents and know there to be an easier way to do this. I have some template documents which contain the right header and footer placements for each of the images, but I, so far, have not been able to translate this into bulk...
  4. F

    1004 Excel Cannot Paste Data (Pictures) To Workbook

    Hey All, Would you be so kind please and help me figure out why the below code only works from time to time but more often than not throws the 1004 error? All I'm trying to do is copy charts without links from one workbook to another. Sheets.Add(After:=Sheets(name1)).Name = charts...
  5. Leonvl

    Insert image for each cell that contains a URL

    I have used the following code to import images based on a URL in a cell range. It allways worked untill recently. The problem is that if there is a blank field within the range, Excel quits immediately. Not sure what to add to skip cells that do not have a value within the range? Thanks, Leon...
  6. S

    Save Workbook Chart as Images

    Hi, I'd like to be able to save all the workbook charts as images. The folder structure would ideally be like this: C:\Users\Pictures\Workbook Name\Sheet Name\Chart Title Name Some code is below which I've started on but am a bit stuck. Any help would be appreciated thanks. Sub...
  7. C

    Extract Images from a PDF using VBA

    I am trying to extract images from a PDF in Excel VBA. I am able to extract all of the text page by page with no problem (code below). I have searched for sample code or an explanation of how to extract images but the only sample code I found did not work. Does anybody know how to extract images...
  8. P

    Saving and consult images with macros

    Hello dear, it is a pleasure to be part of the Mr Excel community. My query is based on the following: I have a budget management system made in excel that uses a spreadsheet to make a certain budget and saves the information of each budget in another spreadsheet that is used as a database to...
  9. S

    Export/Save images loaded to userform to a specific folder

    Hello, Can I please have your help to create a code that allows me to export image1 and image2 to a folder name that changes based on every new entry. The images will be loaded to the user form by click the image shape in the userform. I would like to export or save the images on the a folder...
  10. D

    needing formula to calculate fulfillment needed per day

    I'm a photographer needing help with determining how many images to edit per day in order to meet a deadline. The columns are as follows: D) Status - The status column indicates where the client currently sits in the workflow, such as "Scheduled", "Edit", "Reveal", etc. F) Due Date - The Due...
  11. 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...
  12. L

    Insert Images to Excel Linked Word Table

    I have a VBA code that copies a seelction of cells from Excel and creates a Word table that is linked to the original document. I need to be able to insert images into the created word table. The table will allow me to do this, but each time the link to excel is refreshed the images disappear...
  13. S

    Excel Template sending e-mails

    Morning I have been tasked with "fixing" and excel template created by someone else who no longer works for the company. We fill in the template, press a "clicky" then it saves and send the completed template to the client. The issue is that the company images that appeared in the E-mail are...
  14. B

    Sorting Across the Down with Photos

    I'm creating a database of sorts with Excel. They want a photo page with links to a details page for each item. I'm trying to make a sheet that is 10 columns wide and then raps to the next row. The links are tied to the images so they need to be sortable in the case that a new item is added. I...
  15. J

    VBA Image from HTML

    Using the following URL in cell S2: I am trying to pull all the image Src URL's on the page. Any ideas why this isn't quite correct please? Thanks. Sub Images() Dim XMLPage As New MSXML2.XMLHTTP60 Dim HTMLDoc As New...
  16. J

    One image used in many cells?

    Hi All I have a sheet where all the rows have a product image. There are quite a few rows so loads of images - all thumbnail size. However, the user often needs to duplicate the sheet in other tabs, so in theory all the images are copied too and my file size gets bigger and bigger! Is there a...
  17. S

    VBA - Identifying Image Selected

    I'll use a macro to display several images in a worksheet. Then I'll enter some data in worksheet cells. After that I'll trigger another macro to delete the current images and then trigger the first macro to display a new set of images. All of this works fine. What I'd like to do now is...
  18. Leicester City Fox

    Help with Downloading and finding images that work in Power Bi

    Reference :Help in Easily Downloading new images into Power Bi for chartinfo graphs or find images that can be easily downloading to use in Power Bi Hi there I a new to Power Bi ... so be gentle with me :) I have download images in my picture but when I downloadthem into power bi when I...
  19. A

    Slicer table image issue

    Hello all, Avid consumer of Mr Excel, first time poster. I am building a sortable data table that I want to include images into. I have pasted them into the corresponding cells and when I use a slicer to filter the table, everything works, images move accordingly BUT the images that should be...
  20. S

    VBA to download images and rename

    Hi i have an excel file with links to images in column L i need to download them and rename them with the list in column M Thanks !:):nya:

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