images

  1. 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...
  2. B

    Sorting Across the Down with Photos

    I'm creating a database of sorts with Excel. They want a photo page with links to a details page for each item. I'm trying to make a sheet that is 10 columns wide and then raps to the next row. The links are tied to the images so they need to be sortable in the case that a new item is added. I...
  3. J

    VBA Image from HTML

    Using the following URL in cell S2: https://www.tesco.com/groceries/en-GB/shop/fresh-food/fresh-fruit/bananas I am trying to pull all the image Src URL's on the page. Any ideas why this isn't quite correct please? Thanks. Sub Images() Dim XMLPage As New MSXML2.XMLHTTP60 Dim HTMLDoc As New...
  4. J

    One image used in many cells?

    Hi All I have a sheet where all the rows have a product image. There are quite a few rows so loads of images - all thumbnail size. However, the user often needs to duplicate the sheet in other tabs, so in theory all the images are copied too and my file size gets bigger and bigger! Is there a...
  5. S

    VBA - Identifying Image Selected

    I'll use a macro to display several images in a worksheet. Then I'll enter some data in worksheet cells. After that I'll trigger another macro to delete the current images and then trigger the first macro to display a new set of images. All of this works fine. What I'd like to do now is...
  6. Leicester City Fox

    Help with Downloading and finding images that work in Power Bi

    Reference :Help in Easily Downloading new images into Power Bi for chartinfo graphs or find images that can be easily downloading to use in Power Bi Hi there I a new to Power Bi ... so be gentle with me :) I have download images in my picture but when I downloadthem into power bi when I...
  7. A

    Slicer table image issue

    Hello all, Avid consumer of Mr Excel, first time poster. I am building a sortable data table that I want to include images into. I have pasted them into the corresponding cells and when I use a slicer to filter the table, everything works, images move accordingly BUT the images that should be...
  8. S

    VBA to download images and rename

    Hi i have an excel file with links to images in column L i need to download them and rename them with the list in column M Thanks !:):nya:
  9. H

    Importing Excel Range data to Word doc

    Hello All, I need to import an excel 'Range' which contains texts and images into Word document. I have used the below code. Problem is images are misplaced after importing into word document and few images are above the text content. how do i maintain the structured format even after...
  10. O

    Cannot find this file. Verify the path and file name are correct

    Hi all, I have a macro that will open an email template that contains two images as attachments. when putting the images on my local drive the macro runs perfectly. I'm looking to add the images to a shared drive so multiple users can run the macro but when i try adding the new path i'm getting...
  11. J

    Consolidate and Sum the Rows

    I have tried the basic 'Data' then select 'Consolidate' then 'Sum' etc.....looking for some help to sum up the QTY and SYM and get rid of the dups...I have attached (2) images...the 'Before' and what I'm looking to accomplish with the 'After'...any help with this would be very much appreciated...
  12. M

    List properties of images in workbook

    Hi, Does anyone have some code that can loop through each sheet in the activeworkbook and list all shapes/images and their dimensions / properties? I am most interested in the resolution of the images, but it would be useful to know other info too. Can anyone help? thanks, Mark
  13. S

    Dynamic Picture Viewer

    Hi, I have a list of image file names (minus the extensions) in column A and an Image ActiveX control embedded on Sheet1. Could you help me with a code that would access and display the images? For instance, when a cell in column A containing "Image1" is selected, Excel should access...
  14. kelly mort

    Count images larger than a give size in a folder with vba

    Hello again, I have been searching the net for a while now to find a solution to my problem. I have come close in most cases but not right to the point. I want to go to a folder called "MyImages" in the location on my workbook. That's. ..... ThisWorkbook.Path & "\MyImages". Then I count...
  15. Q

    Randomly display images from a different sheet?

    Context: I am trying to make a question bank to generate different assignment for each student so as to minimize copying... Task: I want to maintain a list of images in a sheet, let us call the sheet as LoI (for List of Images), and then I want randomly display a few of them on the Assignment...
  16. E

    vlookup on images

    Is it possible to use VLOOKUP to pull images from my table? If not VLOOKUP, is there a way?
  17. 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...
  18. D

    Code to delete some images

    I have this code to delete some images on my spreadsheet, but there are now 2 images I don't want the code to delete. The names of them are Image1 and Image2. How can I change it so that it won't delete those images? Private Sub cmdNoSig_Click() ActiveSheet.Unprotect Password:="npssadmin" Dim...
  19. M

    Copy Image from Closed Book & Paste in open

    Hi, I have two workbooks. I am looking to copy an Image from the closed book (Image Source) and paste it into the open book (Source Portfolio.xlsm). The Images are signatures and have been named to correspond with the staff names stored in ComboBox1 ie. J Bloggs would have a signature image...
  20. A

    Insert Images or Files

    What is the best way to insert images into New Threads? I cannot seem to get this feature to work. I am using Snagit to copy screenshots which will assist me in posting my thread and showing exactly my issue, Thank you.

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