EXPERT RESPONSE
Assuming you are using COM to create the Microsoft Excel spreadsheet from LotusScript, you can simply embed the special character directly in your code as follows:
Set xlApp = CreateObject("Excel.application")
. . .
xlapp.cells(1,1).value={ü}
I created the special character in the way you describe, by pressing Alt-129 on the numeric keypad. One odd note: When I tried to set the cell value to Chr(129), I inexplicably got a different character.
Do you have comments on this Ask the Expert Q&A? Let us know.
Related information from SearchDomino.com:
Learning Guide: LotusScript
FAQ: LotusScript
Featured Topic: LotusScript and Excel
Reference Center: LotusScript tips and resources
|
