Re^3: Win32::OLE AddComment method and MS Office 2013

s a defined Win32::OLE object.

Yeah, it should always be a defined Win32::OLE object, because Cells() is documented to always return a Range ... even if the range is EMPTY

Comment on Re^3: Win32::OLE AddComment method and MS Office 2013

Replies are listed 'Best First'.
Re^4: Win32::OLE AddComment method and MS Office 2013 by woland99 (Beadle) on Nov 11, 2014 at 23:54 UTC
I think I located the problem. My code was using modular approach - first add/modify spreadsheet content then a separate routine was adding/modifying comments. I think that there is some problem in the way I handle Excel object in between those two calls. If I combine writing out content and adding comments into one function then program works. Should be simple to debug now. Many thanks for all the answers!	[reply]

Replies are listed 'Best First'.

Re^4: Win32::OLE AddComment method and MS Office 2013
by woland99 (Beadle) on Nov 11, 2014 at 23:54 UTC

I think I located the problem. My code was using modular approach - first add/modify spreadsheet content then a separate routine was adding/modifying comments. I think that there is some problem in the way I handle Excel object in between those two calls. If I combine writing out content and adding comments into one function then program works. Should be simple to debug now. Many thanks for all the answers!

[reply]