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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only