Hi, We are trying to send multiple Navision lines to one Excel cell and would like to use the multi-line feature in Excel, i.e. when typing you can press ALT and ENTER and you can continue on the next line in the same cell. Anybody know if this is possible to automate and if so, how? Many thanks Meint
Separate the text lines with a single LF character (decimal value 10). charLF := 10; xlWorksheet.Cells.Item(1,1).Value := txtLine1 + FORMAT(charLF) + txtLine2;