Code for insert .jpg file
 

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.

Code for insert .jpg file
 

Try
Sub insPic()
Sheets("Sheet1").Shapes.AddPicture _
"C:\Test.jpg", _
True, True, 100, 100, 70, 70
End Sub
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Li Jianyong" wrote:

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.