pictures

  1. A

    Modifying VBA Script to Add Pictures to Excel

    Hello All, I found a script online that I have successfully gotten to add pictures to my excel sheet in the location I want them. :) (Trust me this was an accomplishment I am new to scripting - read Please, please be patient with me and my bumbles here ;)) Here is that script, as I have it...
  2. H

    merge files including macro's

    I have a problem for some month now. I am not sure wether this can be solved. I have 2 files which both have macro's, knobs to activate these macro's and pictures which are manipulated by macro's Now I want to merge these two files including the micro features. Up to now I have copied all...
  3. Y

    Rename pictures in a particular cell

    I have pictures on range F7 in all sheets. unfortunately the names of the picture varies in all the sheets. how do i give it a uniform name like "mypic"
  4. L

    VBA to get name, date and GPS data from pictures in a folder

    I have looked and can't fine code to do this, I have a folder with pictures in it and I would like to put the names of each picture in the folder in column A, date taken in column B and if the pictures have GPS data for them put the latitude in column C and the longitude in column D, can this...
  5. T

    Image File Properties

    Excel VBA is great to read a picture's metadata but it seems tough to have it write any to the file. Ffor a large number of pictures, because it's so much easier to modify the image attributes in Excel than to do it to the pictures individually, I'm looking for a way to take what I write on a...
  6. R

    Automated Pictures In Cells Excel

    Hi All, I am hoping you can help me with something. I am trying to create an automated form on excel where I can automatically input pictures into cells. So for example, I have a picture and text in Cell A1. Is there a way for me to put the same exact text and picture into cell C2 just by...
  7. M

    Selecting Images in Word

    I am producing a report which needs to be run daily. I have some pictures in Excel and I want to copy them and paste them into Word. I need them in a certain location. All this needs to be done in VBA. My proposed way of doing this is by creating template pictures in Word. I assume that I can...
  8. R

    Working with images

    Hi All I have several pictures of equipment to the side of a sheet that is like a library. When I need to grab these pictures, I scroll over to look for it and then copy it and paste it to where I need it. I'm looking for a shortcut that I'm guessing isn't possible. Something like: Type the...
  9. N

    Dynamic Pictures based one someones name

    Hi all, Wondering if you could help me here. I am trying to create some profiles for some players in which I change the name and their picture changes. I have created a table with their picture next to their name and followed some instructions online to make dynamic pictures however I keep...
  10. J

    Resizing pictures already pasted to cells

    I have pictures already pasted into excel cells. I just want to write a macro that will let me change their sizes when I select them. I don't want to paste any new ones and everything I try gives me a 438 error object doesn't support this.
  11. T

    Pictures not working with slicer

    Hi All, I am making an excel dashboard about players performance. I have inserted a slicer (with the names of the players in it), so when I click on it, the different graphs show for this person. But I also want to have the pictures of the players inserted in the dashboard when I click on their...
  12. R

    How to reduce .Xlsm file size

    Hi everyone! My file size is upto 29MB, although no data is entered yet. How can I reduce its size as there is no excessive programming or pictures in it.
  13. ajjava

    VBA code to copy pictures from a workbook into a blank Powerpoint?

    ...bit of the code, but not all of it. The excel file contains what appear to be charts, but they're really pictures. I want a macro to copy any picture on a visible worksheet into a PPT presentation. I have the code worked out to create a new, blank PPT and it does work to copy a few of the...
  14. J

    Pictures Placed Using VBA - Results in Different Locations for Horizontal or Vertical

    I have been using the following code for placing a picture over a cell range in Excel. The code works beautifully for pictures obtained in the horizontal format but when a picture is selected that has a vertical format, the picture is placed far far outside the intended location. It usually...
  15. J

    Pictures Copying on Save?

    I have a spreadsheet with employee pictures that uses a VLOOKUP so when you select John Smith in the dropdown, a picture of John Smith appears in the dashboard along with important employee stats. What is happening is that every day or two, I notice the picture is on top of another picture of...
  16. O

    Hyperlink autofill help

    Hello, I'm trying to simplify the addition of thousands of hyperlinks in a spreadsheet. I have the pictures in a folder and just need to figure out how to get autofill to work with the addressing. The formula below points to the beginning of a series of pictures. How can I drag down and...
  17. A

    Using Index and Match to Lookup Pictures

    Hey everyone, Hope everyone is having a great day :) So I am trying to create a sales dashboard using pivot tables and charts. I have a pivot table in the dashboard that shows the top 10 selling items in the selected category, then I had a great idea to add a section next to it that would show...
  18. R

    Make VBA create linked pictures and move to power point

    Im trying to create a VBA code that will take several ranges from excel, and turn them into linked pictures in a powerpoint presentation, however i cannot get the pictures to become linked. So far, i have managed to combine pieces of code which now makes unlinked pictures and sends those to...
  19. L

    Embed several picture in email

    Hi, I am trying to embed several pictures (they need to be pictures - not based upon the links to the pictures as they are to be emailed to external parties that do not have access to my hard drive) and the following code is displaying the first chart correctly but subsequent ones 2,3,4 etc are...
  20. E

    Pulling (or showing up) a picture based on cell value?

    On worksheet 1, I have a list like the one below. <tbody> A B C 1 List Number Address Picture 2 15 44 Main St ??? 3 16 39 Triangle Ave ??? 4 17 961 Yellow Pkwy ??? </tbody> On worksheet 2, I have pasted pictures from a external source. The pictures are already named and ordered...

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
Back
Top