LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Using VB.Net, How Do I Put a Picture (jpg) Into a Cell ?


"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect a number to a picture bank and import that picture to exce Dennis Hedo Excel Discussion (Misc queries) 1 March 22nd 10 02:17 PM
Inserting a Picture using Cell as picture name. the-jackal Links and Linking in Excel 12 November 10th 08 09:21 AM
how to inset a picture in a cell and make it stay in that cell Louis111 Excel Discussion (Misc queries) 4 March 5th 08 09:15 PM
how do I insert picture into cell so vlookup can return picture? ah Excel Worksheet Functions 1 May 1st 07 04:38 AM
insert a picture in to a comment but picture not save on hard disk Pablo Excel Discussion (Misc queries) 0 February 21st 07 03:48 PM


All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"