pictures

Hi, I am currently running a sheet where I copy an image into a cell in column 'R', now there can be 1 picture or they could be 10 pictures in that 1 cell. But this sheet is filtered and so I need to lock the picture to the cell so that they stick with the same row and keep the sheet tidy. Is...

I would like to create a spreadsheet to change the Date Taken on pictures. There are around 2000 pictures. The file location is in column A (C:\Test) The file name is in column B (Pic1.jpg) The new Date Taken is in column C (11/3/2018) each one will be different The new Date Taken Time is in...

Hello, I have a form I'm attempting to add automatic graphics to and require assistance. I've found a few sites that detail how to link a picture to a cell but unfortunately am having problems getting this to work. Any assistance is greatly appreciated. Background: I have some lines in a...

I’m trying to create a report on excel that produces a red light, yellow light, or green light (all pictures) based on if an inputted number is lower, equal to, or higher than a dynamic number (which steadily increases week after week).So far, I have been able to produce this with a static...

Hi, I have a wksht with 20 pictures in it. Each picture is linked to a range of cells in other wkshts via named ranges. The pictures all update when the cell value in S4 contains 'TRUE' and when the cell value is 'FALSE' the pictures don't update. When I manually type 'TRUE' into S4 or select...

I have been trying to get my ahead around this, however I do not how to use getElementsByClassName to get this done. For instance, from the link: www.cvvillas.com/Destinations/Greece/Kefalonia/Villa-Isicos/Villa-Isicos-Gallery I need to extract the links of the pictures, 14 of them and copy...

Hi I'm attempting to shrink some excel workbooks with lots of graphics inside. I have found the menu options of 'Picture Tools' > 'Format' > 'Compress Pictures' function to be very useful in achieving this. Going through each individual pictures on each sheet and across many workbooks will be...

I am creating an excel sheet for a client and it has many picture names hyperlinked to actual pictures. The problem I have is the I don't know where the client is storing the pictures. So Joe could store them on a network drive and Bill could have them on an external drive and Carol could...

Hi, I have a huge excel product list and I need to insert more then one pictures urls for each product. Here's one example: I have a product reference 10023. For this product there are 3 images in the folder 10023_00.jpg, 10023_set.jpg, 10023_45.jpg. I would like to have all the pictures url...

I have a sheet called Executive Summary, I need to delete all the pictures within the rangeB37 to R107. What is the code for this?

hi all... i have 5 pictures in a sheet..i want remove only 4 pict... how do make it in macros.. here this code but delete all pict.. Sub Kill_Pictures()For Each Shape In ActiveSheet.Shapes If Left(Shape.Name, 7) = "Picture" Then Shape.Delete End If Next End Sub i would like someone help me...

How can I resize hundreds of pictures to the same size at once?

Hi guys, I want a macro that will copy a number of tabs across into a new workbook, and paste values. However, the tabs which need pulling across will vary depending on what the user wants to bring across (although certain tabs will always need to be pulled across: "Summary", "Forecast"...

Hello everybody, Im really new to VBA and Excel and my question might have been asked like a thousand times, however I still didnt manage to complete my goal. Hopefully you can help me. What I want: I want to show images in a cell based on a filepath. Lets say: A1 = Flower A2 = Dog B1 =...

Hi I have two pictures, Picture 1 and Picture 2. I Need a macro that will allow me to assign picture from Picture 1 to Picture 2. If I use shapes with picture fill, I can use PickUp and Apply, yet, I'd rather use pictures. Is there a way to do something similar with pictures? Thx for help

Hi I've got quite a few excel files to redo, each with hundreds of shapes in them. Some of them are pictures, some of them are standard shapes like square, diamond etc. Pictures are a mess and I would like to resize all of them to same size (which they should be in the beginning) Dim ws As...

Hello All, I wanna find out if there is a way to use vba to pick pictures from a folder and place them in cells on a worksheet. By using IDs from cells to make lookups. That is say I have the dataset as: Col A Col B ID PIC 1001 So I will like the vba code use the...

I have column A blank in my employee roles sheet. When I enter their names in column A VLOOKUPS populate other columns with associated data. In the last column used (F) I need to display their pictures automatically. I have the employee pictures on another worksheet in the same workbook. These...

I inserted pictures into cells using the below code. however, suddenly the pictures being inserted started appearing hidden. Can anyone explain? Sub GetShapeFromWeb(strShpUrl As String, rngTarget As Range) Dim Shp As Shape With rngTarget With .Parent...

Inserting pictures into comments is really useful. What I don't understand is to fix the sizing. I know there is "lock aspect ratio" & "relative to original picture size" checkboxes under the "scale" section of the "size" tab when "editing comments". There are many comments with pictures in...