images

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

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

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

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

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>

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

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

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

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

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

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

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

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

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 /...

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

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]...

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

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

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

Hi, I developed a large database in excel(sheet 1). My objective is to extract only specific data and images (sheet2) from this large data (sheet 1). I used dget function to extract data, but dget function does't work to extract images as they dont have any cell address. Above is...