Code for insert .jpg file

[Li Jianyong]

My job needs me insert picture (.jpg file) into excel . I try to record a
macro of this action, it shows empty. Please,any expert, show me a code line
how to insert a picture from .jpg file into excel.

Many thanks.

 

[Sheeloo]

Try
Sub insPic()
Sheets("Sheet1").Shapes.AddPicture _
"C:\Test.jpg", _
True, True, 100, 100, 70, 70
End Sub