I am trying to import pictures into Excel using VBA. My current code allows the user to select the folder in which the pictures are located and then it imports all of the pictures from that folder into excel. I would like to keep the folder selection process the same but only import selected photos. The selected photos would be determined by the photo name in a column of my spreadsheet. Below is my existing code. Any help would be greatly appreciated. I do not want to have to insert the file path into the code. I would like the user to select the folder the files are in and have the macro search that folder for the specific file names in column A and insert the corresponding pictures into excel.

I’m very new to VBA.

I tried recording a macro where any cell containing the text “Hide” is selected and then hidden. After I recorded the macro and tried to run it, I keep getting a Run-time error ‘1004’; No cells were found message.

Bonjour,

I am trying to select the first 14 in Row A which are adjacent to a blank cell within Row C

I have a macro where multiple userforms open and each have their own dedicated “Done” button which unloads the respective userforms.
Now, I have a separate Save function to copy the output sheet to a new workbook and save separately.
My intention is to call this save function when the Done button of the last userform is clicked. (User can randomly choose the order of closing the open userforms.)

Question: I have an Excel VBA macro that works perfectly on my Mac, but when I try to run it on a PC, it doesn’t work as expected. The macro is intended to merge data from multiple Excel files into a single workbook, however, when I try run the Macro on my PC all it does is open a new file with the word “Ready” on the first cell(A1).