images

I need help in linking images when I enter SKU no in a quotation format. I have two sheets, one is a base file in which SKU no is in B2:B4000 and their corresponding images in E2:E4000 (images are inserted into the cell by copy-paste from PPT/PDF/websites- No URL available). Another sheet is the...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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