View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Insert binary image file to Excel

The simplest procedure is to transfer the .bmp file to the computer and to
insert it with:

ActiveSheet.Pictures.Insert( _
"C:\Documents and Settings\Owner\Desktop\Blue Lace 16.bmp").Select

You can use other code to position and size the picture.
--
Gary''s Student


"sexball" wrote:

Hi,

I have a vbscript program that is connected to MS SQL Server 2000. Now, i
would like generate a report which contains some pictures. However, the
image field datatype stored in binary format, not physical path, how can i
insert the image to Excel.

Best Regards,
Sexball