.jpg

  1. V

    Excel Sheet Broke After UserForms With Pictures

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

    File thumbnail on userform

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

    VBA to follow hyperlinks to different files and save in alt folder

    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...
  4. muhammad susanto

    VBA : Change width Column or Height Picture [NOT FIT CELL]

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

    Runtime error 53

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

    URL Image to adjacent cell

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

    URL Image to adjacent cell

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

    Pulling Images from a File Or Folder

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

    Code to insert .jpg from folder based on changing formula result in cell & deleting only inserted image when formula change and not ActiveX controls.

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

    Extract Image From Excel As .JPG To Folder

    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...
  11. kelly mort

    How to use multiple "With"

    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")...
  12. S

    Macro to rename .jpg and .png files with similar names

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

    Filtering & Sorting with .JPG's

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top