Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

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" _
            ).Select
        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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://819186]
help
Chatterbox?
erix just did a 12 km-run. Slow, but unstoppable!
[choroba]: My recent record is 10km in 1 hour :)
[perldigious]: Nice erix... perldigious' legs are so sore from portaging his kayak from place to place last weekend he can barely hobble 12m. :-)
[erix]: you're faster than me then :)
[erix]: well, at the moment, that is :)
[erix]: I should lose some weight although I keep telling myself that I'm doing extra training by lugging it along
[erix]: I saw a common kingfisher and a couple of bullfinches
[erix]: bullfinch ( a male and a female )

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2017-05-24 12:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?