ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to load a .bmp picture into a cell? (https://www.excelbanter.com/excel-programming/323132-how-load-bmp-picture-into-cell.html)

Andrew

How to load a .bmp picture into a cell?
 
Hi, friends,

I am developing an app using VB with Excel library being referenced. I need
to programmatically fill up worksheet cells with text or .bmp picture. Those
pictures are saved in a file system. I know how to put text in a cell, but I
do not know how to load .bmp picture and show it in a cell. Could any one
give me some sample code and reference papers? Thanks a lot.

galimi[_2_]

How to load a .bmp picture into a cell?
 
Andrew,

To insert a picture, you can use

activesheet.picture.insert (full_path_and_picture_as_string)

You can then use then set the .top and .left of those pictures equal to the
..top and .left properties of the cells. Sizing would occur in a similar
fashion.

http://HelpExcel.com

"Andrew" wrote:

Hi, friends,

I am developing an app using VB with Excel library being referenced. I need
to programmatically fill up worksheet cells with text or .bmp picture. Those
pictures are saved in a file system. I know how to put text in a cell, but I
do not know how to load .bmp picture and show it in a cell. Could any one
give me some sample code and reference papers? Thanks a lot.



All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com