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