1. kelly mort

    Code Amendment Needed: Browse And Compress An Image Instead Of Compressing Entire Images In A Folder

    This code was written for me by @Jaafar Tribak long ago. I use it to compress larger images in a folder Now I want to tweak it a little bi: Option Explicit Private Enum PictureTypeConstants vbPicTypeNone = 0 vbPicTypeBitmap = 1 vbPicTypeMetafile = 2 vbPicTypeIcon = 3...
  2. D

    Stop "The linked image cannot be displayed" message from showing on screen,

    This message appears whenever I attempt to insert an image that does not exist. This I would expect except until recently it did not display. I would like to know how I can stop this error message from being displayed. I apologize as I do not know how to include code in a message so I will copy...
  3. M

    What image hosting site would you recommend for use with Power BI?

    Hi Everyone, I am building a report in Power BI that will include upwards of 100 photos. Unfortunately, the image hosting site I'm using (Google Sites) is not working well. Sometimes the photos load, and sometimes they don't. Plus, uploading the photo and copying the link over to Excel is very...
  4. D

    Adding images in table with formatting into Outlook using a file picker

    I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...
  5. T

    How to specify where to insert the Alt Text of an image.

    Is there a way to click on an image in one worksheet and have it insert the Alt Text in another worksheet? Ideally, I would like to select which cell to insert the Alt Text. For example, I have a worksheet filled with images that each have their own Alt Text. I would like to click on any...
  6. M

    Extract images using product code from an XML link

    Hi guys. hope someone can assist me with this. my supplier provide me with an XML file containing all the available products which is updated weekly. the xml file contains a column titled Vendor code. now this is where it gets tricky, in order for me to get the images for a particular product i...
  7. L

    Drawing with text copied from OneNote (as image) only saves pdf as text, but prints normally...

    Lots of variables here, and not exactly an equation, but I'm hoping someone can help shed light on an issue. We draw diagrams with text numbers in OneNote, and then copy that drawing into an excel workbook as a picture (circle our drawing in OneNote, copy, right click excel, paste as picture)...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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