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
|