in reply to Re^3: Create a chart in PPT
in thread Create a chart in PPT

If you define a sub like this

sub explore { my $obj = shift; print "Exploring $obj (".ref($obj).")\n"; if( ref($obj) =~ /Win32::OLE/ ) { for my $key (sort keys %{$obj}) { print "\t$key => ".$obj->$key."\n"; } } }

and then apply it to one of the VB objects like this

explore( $datasheet );

you get all the possible fields you can work with:

Application => Win32::OLE=HASH(0x385ca80) Cells => Win32::OLE=HASH(0x3491660) Columns => Win32::OLE=HASH(0x3491678) Creator => 1297303378 Font => Win32::OLE=HASH(0x34915a0) Height => 0 Left => 4359 Parent => Win32::OLE=HASH(0x3491720) Range => Rows => Win32::OLE=HASH(0x3491708) Top => 4337 Width => 0
.

This way you can find your ways through the VB object djungle (d is silent).