pictures

  1. L

    Using VBA to pull images from folder to sheet

    Hello, I have a folder on my desktop with about 400 jpgs. The images are labeled with numerals like "1.jpg" "2.jpg" "3.jpg" etc. Is there a VBA function that would extract the file name and pictures and put them into an Excel worksheet? Could the cell with the picture be formatted to fit...
  2. S

    Dynamic Pictures as Data Labels in Excel Graph from Pivot Table/Slicer

    I'm trying to create a dynamic graphs based on a pivot table where slicers will be used. I'm trying to figure out a way for the data labels to be the relevant company's logo based on the slicer selections. I've figured out a way to have the labels show as dynamic to a cell, but when I select...
  3. 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...
  4. M

    After change from Picture.Insert to Shape.AddPicture picture image is shifted

    Hi, Hi I had to modify excel template VBA code to make image logo persistent outside the network so I change simple Picture.Insert(pfile) to: Set vOldShape = vSheet.Shapes(pName) If Not vOldShape Is Nothing Then vLeft = vOldShape.Left vTop = vOldShape.Top...
  5. CsJHUN

    VBA slideshow-ish

    Hi guys i would like to create a userform, which load pictures from a folder, and change the pictures every 3-4 seconds, while the user can select between 2 option button ( good or not good). And the picture name,the selected option button value would be registered below each other. The 'sleep'...
  6. S

    Userform Picture and text selection

    Good Morning, I was wondering two things, both interrelated: 1. I have a drop-down box that selects a bunch of info from an array using vlookup formulas and vba coding. Is it possible to have a collection of pictures saved on a sheet in the workbook and then the background of a userform as...
  7. M

    VBA auto-add image to cell from folder

    Dear mrExcellers, In my company we work with a product database with calculations in it, every product offcourse has an unique article number. In the shared server we have a folder with pictures of every product with the article number as the title. We want to add the pictures automatically to...
  8. E

    Import images with column names

    Hey. I had a question of exporting data from Excel to MySQL. There was an acute question with pictures. Pictures must be saved with the names that appear in the next column. How can I do that?
  9. S

    Excel Image resolution change

    Hi I have an excel file that in every row I add a picture to in one of the cells. Pictures are big and I drag them to fit in one cell then I save the file . The problem is when I open the file I want to be able to drag the picture and see the info on it but the pictures resolution has been...
  10. M

    Strange behavior for Excel 365 when deleting pictures

    I have run across some strange behavior, and am wondering if anyone else has experienced this. I have a worksheet where the user can import pictures via VBA code. I also have a couple of checkboxes (form controls) on that sheet. I have a button that allows the user to clear the sheet of all...
  11. E

    Image auto re-sized when inserted

    I am a superintendent for a construction company and I have a workbook that I am currently working on and I am fairly new to excel. It is for daily reports in which I have to add 4 pictures everyday for 6 days a week. I found that if I use a chart it will auto re-size pictures for me cutting...
  12. VBE313

    Excel Sheet Broke After UserForms With Pictures

    What is the best way to add a picture to a userform? .jpg? .gif? .png? etc.
  13. Q

    Select next picture in Excel

    I have an excel sheet containing multiple pictures with object names "Picture 1", "Picture 2", etc. The number of pictures is given by a number in cell A8 I would like to select the pictures one at a time. Currently I have Do While numpic < Range("A8").Value...
  14. muhammad susanto

    VBA : Pulling Picture From Multiple Sheets Into 1 Sheet

    hi expert.. i need vba code to collect/pull only image/photos e.g. jpg or jpeg from several sheets into 1 sheet. my data picture in sheet "hitung1,hitung2,hitung3, etc......" in cell D9 to F9.. i want that pictures can pulled into 1 sheet e.g. sheet1 in cell M2 to O2 down. The pictures must...
  15. T

    Hii

    HI i am new here my name is Christy, I joined this site because i am having trouble with a particular VBA code I want to take information from cells in work sheet2 and put it into work sheet1 last row which already has 1865 rows full of information The Range from sheet1 is B1-B9, (which is a...
  16. R

    No idea how to title...Sorting in Excel to include group header?

    Hi! I'm not sure how to phrase my question which makes hard to search for an answer....Can I sort by a grouping under a heading? I have a sheet that I want to filter (by person), but I want the subheadings (Project name) to be included with the filtering. I can only explain by pictures...
  17. 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...
  18. 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...
  19. 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"
  20. 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...

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