Excel Picture Inserting Macro Help - Urgent
Solved/Closed
nadimn
Posts
3
Registration date
Tuesday April 27, 2010
Status
Member
Last seen
April 28, 2010
-
Apr 27, 2010 at 04:34 PM
jackcluseau - Dec 4, 2014 at 11:26 PM
jackcluseau - Dec 4, 2014 at 11:26 PM
Related:
- Macro insert picture excel
- How to insert a picture into a picture in word - Guide
- Picture manager download - Download - Image viewing and management
- Excel online macros - Guide
- Insert key - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 27, 2010 at 10:15 PM
Apr 27, 2010 at 10:15 PM
Try this. New lines are highlighted
Sub Picture()
Dim picname As String
Dim pasteAt As Integer
Dim lThisRow As Long
lThisRow = 2
Do While (Cells(lThisRow, 2) <> "")
pasteAt = lThisRow
Cells(pasteAt, 1).Select 'This is where picture will be inserted
picname = Cells(lThisRow, 2) 'This is the picture name
present = Dir("C:\Users\Administrator\Desktop\LC\" & picname & ".jpg")
If present <> "" Then
ActiveSheet.Pictures.Insert("C:\Users\Administrator\Desktop\LC\" & picname & ".jpg").Select 'Path to where pictures are stored
'''''''''''''''''''''''''''''''''''''''''''''''''''''''
' This resizes the picture
'''''''''''''''''''''''''''''''''''''''''''''''''''''''
With Selection
'.Left = Range("A6").Left
'.Top = Range("A6").Top
.Left = Cells(pasteAt, 1).Left
.Top = Cells(pasteAt, 1).Top
.ShapeRange.LockAspectRatio = msoFalse
.ShapeRange.Height = 100#
.ShapeRange.Width = 130#
.ShapeRange.Rotation = 0#
End With
Else
Cells(pasteAt, 1) = "No Picture Found"
End If
lThisRow = lThisRow + 1
Loop
Range("A10").Select
Application.ScreenUpdating = True
Exit Sub
ErrNoPhoto:
MsgBox "Unable to Find Photo" 'Shows message box if picture not found
Exit Sub
Range("B20").Select
End Sub
Apr 27, 2010 at 11:20 PM
thank you so much for the help. BUT still there is problem
when I m running this new macro, it pastes pictures and pastes "no picture found" only in first possible cell then it get stuck.both excel visual basic editor get hangs and u can not do anything after that. In task manager it doesnt show not responding thing to excel it shows normal running but actually it is jam..
may be little tweaking here n there required
your m waiting 4 ur quick reply again..
thankyou
Apr 28, 2010 at 06:03 AM
lThisRow = lThisRow + 1
was not at right place. Try now