in reply to Re^4: Win32::OLE Excel AutoFill not working
in thread Win32::OLE Excel AutoFill not working

Glad to hear that you moved forward. Apparently I was wrong in my assumption about Selection, however I think it must then refer to activecell in current workbook/worksheet.

I generally try to avoid using Selection, usually just create couple of Range objects and call methods/write data using them. OLE interface has quite large call overhead, so minimizing number of operations can significantly speedup your app.

-- Roman

  • Comment on Re^5: Win32::OLE Excel AutoFill not working