Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
-no decimals -use 1000 seperator
objXL = ObjectOpen("Excel.Application") objXL.Visible = @TRUE objWorkbooks=objXL.WorkBooks objWorkbooks.Open("C:\temp\data\test.xls") objColumns=objXL.Columns("A:A") objColumns.Select objSelection=objXL.Selection objSelection.NumberFormat = "#,##0" ObjectClose(objSelection) ObjectClose(objColumns) ObjectClose(objWorkbooks) ObjectClose(objXL) Message("Notice","Column A - format successfully changed") exit
Article ID: W16619
File Created: 2005:02:18:12:21:38
Last Updated: 2005:02:18:12:21:38