Excel COM

[andersonbd1]

I'm working with old code that creates an Excel spreadsheet. It already sets the width of columns. I would also like to format the columns so that all numbers are displayed as >>>>>9.99 . Does anyone know what COM function this is? Where can I find thorough documentation on this, so I don't need to post questions like this here?
Thanks,
Ben Anderson

 

[Simon Sweetman]

This is what you are after:

WorkSheet:Columns(lc_col):NumberFormat = "###,##0.00"

The documentation from within the Excel Visual Basic editor is very good (make sure when you install excel you select the VB help and examples).

Of course all the examples and help relate to VB so you will need to experiment to find the Progress equivalent in some cases