Code for insert .jpg file

's Computer Specifications

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 Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to insert a bmp file into Access 2003 table using code	Access Newbie	Microsoft Access VBA Modules	2	24th Apr 2009 01:59 PM
How to insert a module of vba code into an Excel file?	=?Utf-8?B?QmVu?=	Microsoft Access VBA Modules	0	12th Jun 2006 03:16 PM
vba code that insert a hyperlink file in the body of message	gabriel	Microsoft Outlook VBA Programming	3	24th Apr 2006 01:51 PM
how do i insert a code bar or link to a adobe designer file	=?Utf-8?B?THVpcyBBcmVjaGlnYQ==?=	Microsoft Excel Worksheet Functions	1	19th Dec 2005 02:10 AM
Re: How do I insert/update VBA code into a sheet? (using a CLS file?)	Chip Pearson	Microsoft Excel Programming	0	14th Sep 2003 10:37 PM