Picture directory
Closed
SL_ice
TrowaD
- Posts
- 1
- Registration date
- Tuesday September 11, 2018
- Status
- Member
- Last seen
- September 11, 2018
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Picture directory
- Instagram picture downloader chrome - Guide
- Why do my pictures look blurry on instagram story - Guide
- Root directory is full or error in pasting - Forum - Android
- Lg picture in picture - Guide
- Name the artist that drew this picture! - Guide
1 reply
TrowaD
Updated on Sep 11, 2018 at 11:49 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Updated on Sep 11, 2018 at 11:49 AM
Hi SL_ice,
You start that you want to pull a picture from the ID number in column C and you end with that you want to pull in a picture from the name in column A. I went with the latter.
Check out the code below:
Change code line 7 to match your picture directory.
Also check code line 15 to see if it matches your picture extention (.jpg).
Is this to your liking?
Best regards,
Trowa
You start that you want to pull a picture from the ID number in column C and you end with that you want to pull in a picture from the name in column A. I went with the latter.
Check out the code below:
Sub RunMe() Dim xRow, xCol As Integer Dim PictPath As String xRow = 1 xCol = 1 PictPath = "C:\MyPictures\" Sheets("Housing Roster").Select For Each cell In Range("A3:A130") With Sheets("Picture Directory Test") .Select .Cells(xRow, xCol).Select .Pictures.Insert(PictPath & cell.Value & ".jpg").Select End With If xCol = 10 Then xCol = 1 xRow = xRow + 5 Else xCol = xCol + 3 End If Next cell End Sub
Change code line 7 to match your picture directory.
Also check code line 15 to see if it matches your picture extention (.jpg).
Is this to your liking?
Best regards,
Trowa