Question Using Font Size And Style In Header Of A Msexcel Output

[Arjon M. Policar]

Greetings!
Hello! Everyone, I'm new in progress programming, can you please help me how to change my header font size and font style? I use the MSExcel for my output on my sample program for my practice. Thank you .

 

[Osborne]

You have not said how you are creating the Excel file. If it is created using COM-HANDLES then take a look this article:

Progress KB - 4GL/ABL:  How to CenterHeader in Microsoft Excel?

Basically, to set the font size and style you have something like this:

hExcel:ActiveSheet:PageSetup:CenterHeader = "&B&""Courier New""&10 Bold Courier New Size 10&B&""Arial"" Arial Font".

 

[Cringer]

If you're using COM-HANDLEs then the best way to work out how to do something is to record a macro of you doing it and look at the code behind the macro. It doesn't translate directly but it will point you in the right direction for the properties and methods available.

 

[Arjon M. Policar]

You have not said how you are creating the Excel file. If it is created using COM-HANDLES then take a look this article:

Progress KB - 4GL/ABL: How to CenterHeader in Microsoft Excel?

Basically, to set the font size and style you have something like this:

hExcel:ActiveSheet:PageSetup:CenterHeader = "&B&""Courier New""&10 Bold Courier New Size 10&B&""Arial"" Arial Font".

Thank you Sir. I will read this article and try.

 

[Arjon M. Policar]

If you're using COM-HANDLEs then the best way to work out how to do something is to record a macro of you doing it and look at the code behind the macro. It doesn't translate directly but it will point you in the right direction for the properties and methods available.

Thank you Sir. I will follow the guidelines from now on.