How to load a .bmp picture into a cell?

A

Andrew

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.
 
G

galimi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to load a .bmp file and show it in a cell? 0
Loading Pictures in Image box 5
Conditionally load picture woes 2
Loading and changing a photo 0
VB.NET Inserted Picture Ends Up in Wrong Cell 1
Pictures in Cells 4
Creating Labels Over 3-Up Image 2
Refereing to a picture in a excel cell 3

Top