| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i insert a code bar or link to a adobe designer file | Excel Worksheet Functions | |||
| Import VBA Code in Excel-File ? (Export VBA Code to file) | Excel Programming | |||
| Insert VBA code with a macro in a .xls file by workbook open event | Excel Programming | |||
| VBA-How to insert vba code file in a project using coding rather than manual import | Excel Programming | |||
| How do I insert/update VBA code into a sheet? (using a CLS file?) | Excel Programming | |||
Linear Mode
