Thread:Project:Support desk/Questions about ADODB.Stream Used in OpenOffice

In VBA, ADODB.Stream is used successfully like following: Set objReadStream = CreateObject("ADODB.Stream") Set objWriteStream = CreateObject("ADODB.Stream")

With objReadStream .Open .Type = adTypeText .CharSet = "SHIFT-JIS" .LineSeparator = adCrLf End With With objWriteStream .Open .Position = 0 .Type = adTypeText .Position = 3 .CharSet = "UTF-8" .LineSeparator = adCrLf End With However, when these codes used in OpenOffice, the calc can't recognize these code: objWriteStream.LineSeparator = adCrLf objWriteStream.Position = 0 ... Why this happened? And can anybody tell me how to use the 'ADODB.Stream' correctly in OpenOffice, please. Thanks a lot!!