| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a Picture using Cell as picture name. | Links and Linking in Excel | |||
| how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
| cannot load excel file - "too many different cell formats" error s | Excel Discussion (Misc queries) | |||
| Load active cell data via a function | Excel Worksheet Functions | |||
| Excel 2000 Load Userform when clicking cell | Excel Programming | |||
Linear Mode
