pictures

I want to loop through a directory of excel files and insert pictures from another directory that goes down the line of excel files and inserts the pictures one after the other in the picture directory. Below is the code to help show what I mean. I want the insert picture to be on the...

A wonderful forum member (Perpa) helped me modify some code he posted to insert images in rows of 3 in a spreadsheet. He suggested I start a new thread for further modifications. The macro works very well to insert images in a fresh sheet; however, I need to designate the starting point. For...

hi expert.... this code work properly only for 3 pictures to inserted into 3 cells, but i want to modify how this code below work in n pictures (multiple pictures) then inserted only in cell H10 for each sheet.. Sub InsertPic() Dim I As Long Dim xPath As String Dim xShape As...

hello... i need your help about macro code to delete all pictures in multiple sheets (all sheet).. any body help, thanks in advance.. m.sst

I am creating client reports that will need up to 200 pictures. I have the code to insert them, but it brings them in as linked objects, so clients can't see them since the pictures aren't on their network. I found some code to insert them as shapes, but I'm not advanced enough to adapt my...

Dears, I have a big range of data of spare parts where I need to find the right part and press hyperlink to view the picture of the part, is it possible to sort the pictures which linked to a certain Manufacturer or other certain cell related to the part, so if I filtered the excel sheet I can...

Hi Guys, how is everything? I have excel sheet contains 3 pictures, Picture1, Picture2 and Picture3. How to write VBA code to open specific existing PowerPoint file, delete any pictures in this PowerPoint file first, and then to copy Picture1 and paste in slide 2, Picture2 in slide 5 and...

Hello In folder "C:\Pictures" from my pc I Have 3 pictures (first pictures it's called "car" // 2nd pictures "dog" // 3rd pictures "horse") all in format .jpg In an active workbook in sheet1 I have in Cell A1 inserted word car...

I am trying to insert text and pictures from a specific folder to a hidden Excel file, in specific cells, but for some reason I do not succeed in adding the pictures to the file. What I can is open a hidden Excel file and add a bunch of data to the Excel. I can also add pictures tot the Excel...

Hi guys, I have the following macro which works as follows: once run, it reads the product codes (e.g. 12381-1231) in column B and inserts corresponding product pictures from another folder to the excel file. Now the problem is that even when I save the document and then send it to others, they...

I've been having issues with Lookup function in excel. It seems to work for some rows but won't work for 2 out 4 rows. I appreciate if someone could help me with it. Thanks in advance. =LOOKUP(B6,$A$16:$A$19,$B$16:$B$19)

Hi, I am trying to re-build a workbook with the following criteria. I have since left my old company and I can't remember how the Macro was written and the files it was linked to don't exist on my computer. Please help :) Thanks in advance. Objective: To use a Macro/Formula to populate a jpeg...

Hi all. I've been using and adjusting an original function that came from this forum and have searched if someone has had this requirement before but coming up blank. I'm looking to add a rotation to the displayed images and wonder if someone can help with the code? Here is what i have...

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

Hi, I have the code below which selects a range in excel and prints it to a PDF. The range is mainly made up of text boxes, graphs, shapes and 3 pictures. The quality in the PDF is excellent apart from the pictures which are poor (fuzzy) and let the rest down. Any ideas of how I could change the...

Good afternoon, I have the following code which works well at resizing all the pictures to a set size. I can't however work out how to centre all the pictures at the same time though! Sub Resize_Images1() Dim i As Long With Application .ScreenUpdating = False: .DisplayAlerts =...

I have a spreadsheet that has product pictures and data like sku's, cost, etc. But the person who created it did not format the pictures to move and resize with cells. Can I correct all pictures via a macro? Don't want to do hundreds of manual corrections.

I'm using a VBA macro to load 15 pictures in various positions in an Excel worksheet. I'll examine those pictures, delete them, then load some more. The process repeats hundreds of times. This works fine if I want to delete all the pictures that I load. However, I'd like to add some shapes...

Hello Everyone! I've read a couple of posts explaining how this can be done, but haven't really found a way to make it work for me I have a workbook with 2 sheets Sheet 2 has all the data + pictures Sheet 1 is where I work I type a specific # on A2 and vlookups return information on B2...

Hi All, I want a macro that remove hyperlink from all the pictures in an excel worksheet. Please help me. Thank you. Regards,