Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default insert picture into worksheet cell

I'm not sure if this is what you after or that the syntax is correct:

dim oPic as excel.shape
set oPic = moExcel.moExcel.ActiveCell.Worksheet.Pictures.Inse rt
("c:\temp\sig.jpg")
oPic.name = "sig"

"Matt" wrote in message
...
I'm having a problem inserting a picture file into a
worksheet using VB 6.0. The VBA macro equivalent code is:

ActiveSheet.Pictures.Insert("C:\TEMP\sig.jpg").Sel ect

I can't access the Pictures collection from VB 6.0 code.
I'd expect this to work (moExcel is a global
excel.application):


But there is no Pictures collection available. Any
assistance is greatly appreciated.

Matt Kiner



Reply
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
Insert a picture in worksheet baha Excel Discussion (Misc queries) 1 September 28th 09 01:25 PM
How do I insert a picture into a cell? Evan Lapka Excel Discussion (Misc queries) 1 June 21st 07 12:05 AM
how do I insert picture into cell so vlookup can return picture? ah Excel Worksheet Functions 1 May 1st 07 04:38 AM
How can I insert a picture from file while worksheet is protected ChrisYH Excel Discussion (Misc queries) 0 July 27th 05 04:25 AM
insert picture in header section of excel worksheet bhavini Excel Discussion (Misc queries) 4 February 22nd 05 08:43 PM


All times are GMT +1. The time now is 12:59 PM.

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

About Us

"It's about Microsoft Excel"