August 27, 2018

Place an Image in Database Worksheet

How to place an image or picture in the database worksheet automatically with VBA.
When we place an image of the customer, employee or student in our database, we have another criteria to manage our business relationships in a more effective manner.Watch the video:


Watch this video on YouTube.

Here’s the complete VBA code to place a ‘.jpg’ picture in an Excel worksheet:

Sub displayPic()
Application.ScreenUpdating = False
Dim myObj
Dim Pictur
Set myObj = ActiveSheet.DrawingObjects
For Each Pictur In myObj
If Left(Pictur.Name, 7) = “Picture” Then
End If

Dim EmployeeName As String, T As String

myDir = “C:\Users\takyar\Pictures\employees\”
EmployeeName = Range(“E2”) & Range(“E3”)
T = “.jpg”

‘Range(“F2”).Value = EmployeeName
On Error GoTo errormessage:
ActiveSheet.Shapes.AddPicture Filename:=myDir & EmployeeName & T, linktofile:=msoFalse, savewithdocument:=msoTrue, Left:=420, Top:=15, Width:=60, Height:=60

If Err.Number = 1004 Then
MsgBox “File does not exist.” & vbCrLf & “Check the name of the employee!”
Range(“E2”).Value = “”
Range(“E3”).Value = “”
End If

Application.ScreenUpdating = True

End Sub

Further Reading

Place Picture in Excel Worksheet Cell Using VBA