Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Adding pictures to Excel

by davies (Parson)
on Jan 23, 2010 at 14:02 UTC ( #819186=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
        ActiveSheet.Pictures.Insert( _
            "C:\Documents and Settings\All Users\Documents\My Pictures\Sam
    +ple Pictures\Blue hills.jpg" _
            "C:\Documents and Settings\All Users\Documents\My Pictures\Sam
    +ple Pictures\Sunset.jpg" _
        Selection.ShapeRange.IncrementTop 290.25
  2. or download this
    Dim picCurrent As Picture
    Dim shtPics As Worksheet
    Set picCurrent = shtPics.Pictures.Insert(ksPic2)
    picCurrent.Top = 130
    picCurrent.Left = 280
  3. or download this
    use strict;
    use warnings;
    $picCurrent = $shtPics->Pictures->Insert(second pic);
    $picCurrent->Top = 130;
    $picCurrent->Left = 280;

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://819186]
talexb thinks the term 'cookie monster' is unnecessarily drogatory ;) and takes a cookie as well. Mmmm. Delicious cookies.
[davido]: A tool as pretentious as Test::Perl::Critic ought not fail to install because one of its dependencies failed to pull in List::MoreUtils.
[davido]: ...and

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (11)
As of 2017-04-25 16:02 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (458 votes). Check out past polls.