Code for insert .jpg file

L

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.
 
S

Sheeloo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
recover jpg 0
Insert multiple objects at once ? 3
How to insert Certificated digital signature in Word for Mac 0
Working outlook via vba code with xlsx - error 0
AppleScript - How do I select a text ? 1
File size gets huge on photo insert 4
Insert Picture using Macro & Validation list 5

Top