Related:
- Inserting pictures from folder using macro
- Anvi folder locker reset key - Guide
- How to rotate all pictures in a folder at once - Guide
- Steam screenshot folder - Guide
- Ps3 update folder - Guide
- Recover files from hidden winmend folder - Hard Drive & SSD Forum
1 response
Well good luck with this. Excel is for calculating complex mathematical equations, not an interface for images. Even if the code will insert it into the row and column you wish, if the images are not all the same size, it will WRECK the formatting of your columns, making them unreadable.
Which part of the scripting are you having issues with?
Here is short code for you to play with in the sandbox!
Which part of the scripting are you having issues with?
Here is short code for you to play with in the sandbox!
Sub insert()
picpath = "e:\pictureshare\smiley1.jpg"
With ActiveSheet.Pictures.insert(picpath)
With .ShapeRange
.LockAspectRatio = msoTrue
.Width = 75
.Height = 100
End With
.Left = ActiveSheet.Cells(1, 20).Left
.Top = ActiveSheet.Cells(1, 20).Top
.Placement = 1
.PrintObject = True
End With
End Sub