Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a picture in worksheet | Excel Discussion (Misc queries) | |||
How do I insert a picture into a cell? | Excel Discussion (Misc queries) | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
How can I insert a picture from file while worksheet is protected | Excel Discussion (Misc queries) | |||
insert picture in header section of excel worksheet | Excel Discussion (Misc queries) |