.jpg

Hi Guys, Am trying to get all the jpg file names related to 1 product. e.g. this is the product name 37004378_TM search this in file explorer & copy all the result file names like 37004378_TM-99999999_01.jpg 37004378_TM.jpg 37004378_TM_B.jpg 37004378_TM_B3.jpg 37004378_TM_D1.jpg...

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

how can one display the thumbnails of files that are in a listbox especially for .jpg, .cdr?

I have a workbook with a column of 1000+ hyperlinks that link to numerous files of different types in numerous different folder locations on one drive and I want to automate the process of saving those documents to one folder location using the adjacent cell as the file name. There will be a mix...

hi all.. this macro code work properly for fit cell, i want to change column width height row in left margin and right margin [not fit cell] Sub InsertPic() Dim I As Long Dim xPath As String Dim xShape As Shape Dim a As Range xPath = "L:\test\" If...

hello friends Newly I am studying excel VBA. when i am coding one school program Run time 53 (file not found) error occurred. Me.Image1.Picture = LoadPicture(ThisWorkbook.Path & "" & TextBox1.Value & ".jpg") please tell me what is wrong in this? and explain me about these codes. Thanks Apolin

Good Morning all, I've been tasked with the following and could really use some help! Column H starting at cell H2 has hyperlinks which lead to an image (but not a .jpg, just a url that has an image in it) I am looking for a macro or a way that when I click the hyperlink, it returns the image...

Good Morning all, I've been tasked with the following and could really use some help! Column H starting at cell H2 has hyperlinks which lead to an image (but not a .jpg, just a url that has an image in it) I am looking for a macro or a way that will click the hyperlink and return the image in...

Hi, Is there a formula for pulling images into excel? The images are either in another excel spreadsheet (ie. I could do a vlookup, but to pull the image in) or the images are located in a particular folder. Thank you.

Hi, humbly requesting assistance. 1. I have the code below which inserts a picture from a folder D:\CLLT\CLLT Images into "K4" based on the picture name in "P5". It works perfectly fine if I change "P5" manually. 2. How do I change the code if "P5" is an "if formula" which...

Hi, I need a code that will save all pictures in a sheet, picture 1 will be in B2 with filename in C2 e.g name & ".jpg". Picture 2 in B3 etc.. I need it to check if theres a picture in B2, B3 etc.. I need it to check if file path already exists, if it does then next loop otherwise save in...

Hello all, I need help with how to use multiple with in a procedure. I want to use them to reference Worksheets. So say I have four sheets . For i = 1 To 20 With Sheet1 .OLEObjects("Image" & i).Object.Picture = LoadPicture(fPath & "\" & .Cells(10 * i - 8, "B") & ".jpg")...

Hi Team, I need to write a Macro, which will find all .jpg and .png files in a folder with same names and rname them seq as 1.jpg, 1.png, 2.jpg, 2.png and so on................... Please note that even after renaming both files will be under the same names only...............But instead of...

Hi, I have a bunch of .jpg's that correspond to a series of data on each row of a document. When I filter the document and try to sort, the .jpg's do not follow the reorganization of the rows. I think excel views them as an shape, and therefore, will not move them. Is there any way to...