Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "eBob.com" wrote in message ... I am creating an Excel 2002 sheet programmatically using VB.Net. It all works fine. But now I'd like to add a photograph to each row. I've done searches but all the hits I get must be for VBA rather than VB.Net. In any event the hits have not helped. I'm aware of HOWTO: Automate Microsoft Excel from Visual Basic .NET http://support.microsoft.com/default...b;en-us;301982 but that doesn't illustrate how to put a photograph (jpg or similar) into a cell. Any pointers will sure be appreciated. Thanks, Bob For anything you don't know how to do programmatically in Excel a good starting point is the Macro recorder. Start the Macro recorder, choose/move input cell, click menus etc, stop the recorder and see what code it produces. For the VB .Net Excel automation program in your link, the following inserts a pictu oSheet.Range("K2").Select() oSheet.Pictures.Insert( "C:\temp\myPicture.JPG") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Connect a number to a picture bank and import that picture to exce | Excel Discussion (Misc queries) | |||
Inserting a Picture using Cell as picture name. | Links and Linking in Excel | |||
how to inset a picture in a cell and make it stay in that cell | Excel Discussion (Misc queries) | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) |