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

[Anonymous Monk]

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

[woland99]

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!