programatically formatting a column to text wrap RRS feed

  • Question


    Hi everyone;


    I have a table being exported to Excel from Visual Foxpro.  One of the columns needs to have text wrapping set to on.  Is this possible to do from the application object?


    I have tried this..



    ** after copying change text wrap in column 7 to true

    loExcel = CREATEOBJECT("Excel.Application")


    loExcel.WorkBooks(1).Worksheets(1).Columns(7).Cells.WrapText = .T.


    loExcel.Quit() && If you don't do this, it seems to leave a hidden copy of Excel open

    loExcel = NULL


    but it doesn't work.



    Wednesday, January 2, 2008 6:06 PM