Excel automation border

Business Central/NAV Developers Forum
1

Hi, What i do wrong?? Why string: autSheet.Range(‘A7’).Borders.LineStyle:=‘xlContinuous’; get automation error, when other strings: autSheet.Range(‘A7’).Font.Bold:=TRUE; are OK??? RGDS

2

Because of wrong type of constant you’re use. autSheet.Range(‘A7’).Borders.LineStyle:= <----- right syntax. xlContinuous = 7 as i remember. You can use msgbox(xlContinuous) in Visual Basic to know the value of this (and any other) constant. Best regards.

3

Sorry, xlContinuous = 1.