Hi.I have some code that is copying and pasting the contents of a rich text field from a Lotus database into an Excel spreadsheet.
The content of the RT field is an image, but unfortunately the image is apparently being enlarged slightly from its original size during the Copy & Paste process.
The result of this is that the image turns up in the Excel spreadsheet as a lower definition picture, with visible stepping in what are supposed to be straight lines.
I’m a relative newcomer to LotusScript, so I don’t know a great deal about OLE/COM programming (which I assume is involved in this.)
But the key lines of code currently being used to perform the Copy & Paste operation are:
Set range1 = excelSheet.Range(“t”&count+1)
Call range1.PasteSpecial(-4104)
My question is this:
Is there a way to lock the size of the image during the Copy and Paste process, so that it appears in the Excel spreadsheet exactly the same size as it was originally?
Thanks in advance for your help.