<?xml version="1.0" encoding="windows-1252"?>
<node id="1008376" title="Re^2: Using Win32::OLE and Excel - Tips and Tricks" created="2012-12-11 14:22:11" updated="2012-12-11 14:22:11">
<type id="11">
note</type>
<author id="951692">
HelenCr</author>
<data>
<field name="doctext">
&lt;p&gt;This piece of code doesn't work because "Selection" is a method of the parent Excel application, not the sheet.&lt;/p&gt;

&lt;p&gt;So if you had, in the beginning of your code:&lt;/p&gt;&lt;c&gt;
my $XcelApp = Win32::OLE-&gt;new( 'Excel.Application' );&lt;/c&gt;&lt;p&gt;Then the second line in your post should go:&lt;/p&gt;&lt;c&gt;$XcelApp-&gt;Selection-&gt;Copy('A17');&lt;/c&gt;&lt;p&gt;Helen&lt;/p&gt;</field>
<field name="root_node">
153486</field>
<field name="parent_node">
664186</field>
</data>
</node>
