Skip to Content
0
Former Member
Jul 20, 2009 at 02:29 AM

How to adjust excel column width

1965 Views

Hi Expert,

I need to write data into excel sheet using Excel OLE object, And now I've face the problem that I need to adjust column width of the excel sheet but I don't know how to work with Excel column.

I've record Excel Macro and got below code ..

Sub Macro2()

'

' Macro2 Macro

' Macro recorded 20/7/2009 by AA

'

'

Range("B1").Select

Columns("B:B").ColumnWidth = 21.57

End Sub

How to convert 'Columns("B:B").ColumnWidth = 21.57' to ABAP Code ?

Please give me an advice

Thanks in advance.

Nattapash