View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kiat kiat is offline
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