where did you get your #include "xlconstants.h" ? i assume that has the definition of xlgeneral and xltop? would love to have a copy.

thanks

brenda


>Brenda,
>As your thread gets long I thought might not be solved already. If did discard :

>Use testmemo && Samples employee as test table
>=Table2ClipBoard()
>#include "xlconstants.h"
>oExcel = createobject("Excel.Application")
>With oExcel
.Workbooks.Add
.visible = .t.
With .ActiveWorkbook.ActiveSheet
.Paste
.Range('A1').CurrentRegion.Replace("PMARK",chr(10),xlPart,xlByRows, .F.)
Endwith
With .Selection
.ColumnWidth = 50 && Increase width for memo
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlTop
.WrapText = .T.
Endwith
>Endwith