in reply to Win32::OLE Excel question

Just translate Columns("M:N").Select to Perl code, like you did with the rest. Possibly see VBA 2 Perl. Where exactly are you having problems?

Replies are listed 'Best First'.
Re^2: Win32::OLE Excel question
by imrags (Monk) on Jan 05, 2009 at 09:14 UTC
    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
[reply]

      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