Hello
I am sending query to Excel and everything is ok if in References is Excel 15.0 Object Library. To avoid Excel version I made it late binding..and everything is ok until the code reach this line:
.Range("A4:F4").Borders(xlEdgeTop).LineStyle = XlLineStyle.xlContinuous
I got this message: Variable not defined for "XlLineStyle"
Where and how to define this variable?
Thanks
I am sending query to Excel and everything is ok if in References is Excel 15.0 Object Library. To avoid Excel version I made it late binding..and everything is ok until the code reach this line:
.Range("A4:F4").Borders(xlEdgeTop).LineStyle = XlLineStyle.xlContinuous
I got this message: Variable not defined for "XlLineStyle"
Where and how to define this variable?
Thanks