Insert binary image file to Excel
 

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

Insert binary image file to Excel
 

Hi all,

I'm not using vbscript, i'm using MS visual basic

Best Regards,
Sexball



"sexball" bl...
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

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