Storing pictures in JPG-files uses about 20 times less space than in general fields. In this case, my database only has a small character field that points to the filename.
If you work this way, the command would be something like:
with loSheet
.Range("A1").Select
.Pictures.Insert(lcImageFile)
endwithHilmar.
>Hi, everyone
>
>I want to generate a PRICE LIST from my database into EXCEL file format.
>I coding below command as below :-
>
>EXCEL_FILE.APPLICATION.CELLS(1,4).VALUE = "ITEM NO. : " + PRO_CODE
>
>now... i want to put a photo into CELLS(1,5), the photo was stord in database.field [MyProduct.photo]
>
>How ???
>
>I make it, cause i want to send the Price List (Excel) to my client with photo. If the Excel is not the best ways, what suggest for ?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
