images

  1. A

    vba to show images in comment box causing Out of Memory

    Hi, I have some VBA to take a path from the 2nd column and show an image for the cell that has been clicked using the comment box to display the image It looks great, hopefully others can use it if this error gets cleared up Example sheet <tbody> <tbody> <tbody> ML053 </tbody>...
  2. B

    Inserting images and resizing on different sheet

    Hi guys, I have tried some of the stuff I saw here but it isn't really working for me and I hope you can help. Basically I have a product catalogue sheet where there's a list of items and I would like to import images from my folder depending on the item ID. -There are 2 tabs on my file -"Item...
  3. neilp

    images on a userform

    Hi, Wondering if this was possible. If i have 5 images on a userform, is it possible for them to be changed according to a dropdown. eg if each image was saved in the same folder according to a set naming schedule ie Peter1.jpg, Peter2.jpg, Peter3.jpg, Jane1.jpg, Jane2.jpg, is there a way that...
  4. E

    Selecting Everything In a Range

    I have a worksheet that has data and images on it. I want to e-mail everything that is visible in a given range, including the images. I can already select all the data and put it in the e-mail using Set rng = Sheets("Invoice").Range("A1:I151").SpecialCells(xlCellTypeVisible) but I need the...
  5. N

    image assistant - images not loading

    Hi, I have been using image assistant for a while to upload images in excel based on file name. When I send the file everything looks good. But whoever receives it, outside of my company (who has access to these images on our shared network) cannot see the images. It has an "X" instead of an...
  6. 2

    Download Images from Urls

    Column A contains urls, need vba module to download the images from these urls/hyperlinks to desktop. The below link has been converted to hyperlink in excel <tbody> http://i723.photobucket.com/albums/ww237/sukkhi2/Stock 23/Stock 23 Remaining/26ALPHAZ340_zpssoxAB3fbh.jpg </tbody>
  7. Leonvl

    Add multiple pictures from local directory

    I uded the below code to insert pictures based on a URL on the web based on a cell value which worked fine. Now I would like to insert pictures for a range from a local folder, but that apparently doesnt work with the Parent.Pictures.Insert method. Played a bit with the Shapes.AddPicture method...
  8. M

    Require a way to create if statement for images

    ok so my problem is that i currently have two rows of images, one for home kits and one for away kit images for a football database i entered. this being my current formula to pull the image dependent on the match that is requested by the user...
  9. S

    VBA: Capture Computer Name and Insert it into String.

    Hello, I'd like to be able to send this file to other people and have it work for them, without having to go through some of the VBA editing that I must go through presently. The macro works fine, but when it goes all the way to the file destination, it says that nothing is present. What this...
  10. H

    Get the color of small images

    Hi! I import some data from Word document and paste it into a worksheet. The word document contain both text and many small images. The images are only with 4 colors, but many of them. I want to get the color of images. I get the RGB color number, but they all have the same number. It should...
  11. N

    Export report to Word document

    Hello and thank you for any attention my post may receive. I have a report in my Access db which I would like to export as a DOC or RTF so that images can be pasted to it, rather than import the images in the db which will take up too much room. I can successfully export the report as both DOC...
  12. M

    Inserting images from online folders without knowing the file name - VBA

    Hi all! I'm having some trouble trying to recover a number of images from an online server. I can manage to insert an image knowing it's absolute path + filename, but I just know the path.. The name of the *.jpg that's inside each folder is arbitrary, I just know that inside each directory...
  13. M

    Cutting and pasting inserted image

    I am using the following in a loop to add 3 different images to a worksheet and then place in the correct location. Multiple files are created but use only the same 3 imagesSet objImage = ActiveSheet.Pictures.Insert(ActiveWorkbook.Path & "\Images\" & strImageFile) objImage.Cut...
  14. K

    re photos

    hello friends am on a small school, project and i wish one to help me with a code which can import photos to one page and display 1 image per cell value on the next page. on the next page i used navigation buttons and i wish to use those to scroll through the images on sheet 1 one by one. thank you
  15. M

    Save Images To Disk Using the URLs In A Spreadsheet

    Hi, I have a spreadsheet with a bunch of image URLs (A2:A1550). The URL format is domain.com/blah/123456.jpg or domain.com/blah/123456.png The numerical part varies (image names are different). I want to save all the images to a local folder, let's say C:\Temp using the name after the last /...
  16. G

    Show Images instead of URL into a Cell?

    Good Day to All! I have a table that contains links/URL to a specifict images and i want them to show up on a different sheet on a specific cell. Image URL are: I2, I3, I4 on Product Table Sheet. Image with fix size of 290 x 290 (centered if possible) should show up on cell: A2, B2, C2 on...
  17. D

    VBA Transpose Cells with Images

    Hi is it possible to transpose cells containing images and numbers, I have 1000+ Rows in column A where each cell has a number and image but what I would like to do is transpose by every 10 cells. From this <tbody> [Image] 1 [Image] 2 [Image] 3 [Image] 4 [Image] 5 [Image]...
  18. G

    How to convert image addresses to images in entire column in Sheets

    Hello! I tried to find the best board, so I hope this one is ok. I currently have a column composed entirely of image addresses. I need to convert them all to images using =image("**") I really don't want to have to go an add =image("") to all of the links and would really appreciate it if...
  19. jlhoover3

    Stacking Pictures Vertically VBA

    Hello everyone! I am having problems figuring out a way to stack images or place images vertically on excel. When saying that, I want to insert a picture and have it move directly below the previous image that was inserted. Usually this wouldn't be a problem, however the images have a...
  20. C

    Dynamic Image Spacing using VBA

    Hey All, Need some help, I am currently importing information from text files into excel with a loop. Each line in the text files relates to an image in a separate folder which it pulls in and then aligns it in the correct space. This works great when each text file is imported into its own...

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