in reply to Re: Win32::OLE Excel formula Copy
in thread Win32::OLE Excel formula Copy

Thanks for the solution. But I am looking for a more generic solution as I have around 50 different formulas to be substituted with new row and they are spread into different columns . eg. 
 
=IF(C489=0,0,(ABS(C492-C489)/C489))

[download]
in the above formula above substitution $Formula1 =~ s/\d+/$new_row/g; will not work.

Replies are listed 'Best First'.
Re^3: Win32::OLE Excel formula Copy
by moritz (Cardinal) on Nov 25, 2008 at 14:13 UTC
    If you want the behaviour of the copy & paste mechanism, you should try to use that: select the cells, copy them, move the cursor to another cell, paste there.

    I'm not familiar with OLE at all, but I'm quite sure that this has to work somehow, and I even suspect you'll find some code examples if you search hard enough.

[reply]

In Section Seekers of Perl Wisdom