Discussion Board for collaboration on QlikView Scripting.
My VBscript for columnwidth is working but the alignment is not.
Any ideas why this would not work in an inline process??
objCurrentSheet.Columns("A").ColumnWidth = 35objCurrentSheet.Columns("B").ColumnWidth = 125 objCurrentSheet.Columns("A").HorizontalAlignment = xlHAlignLeft
The xl-constants won't be regocnized in each case. You could try it only with xlLeft but mostly are the numeric equivalent from these xl-constants better to use. In your case try it with 3:
objCurrentSheet.Columns("A").HorizontalAlignment = xlHAlignLeft
Helpful is the using of the excel-vba direct-window and there:
?VarType(xlHAlignLeft) // and then enter