in reply to Re: Win32::OLE Excel question
in thread Win32::OLE Excel question

The problem is that it selects those 2 rows and sorts
accordingly but it sorts the whole sheet while doing so
which is something i don't want.
I only want those 2 columns to be sorted.
Raghu

Replies are listed 'Best First'.
Re^3: Win32::OLE Excel question
by Corion (Patriarch) on Jan 05, 2009 at 09:32 UTC

    In your Perl code, you don't set $Excel->Selection. You need to do that, like you do in your VB code.

[reply]
[d/l]

In Section Seekers of Perl Wisdom