请问如何在VB6.0中设置EXCEL单元格的颜色和边框(请教各位高手)
Set sApp = CreateObject("Excel.Application")
PathMap = App.Path & "\test.xls"
Set sBook = sApp.Workbooks.Open(PathMap)
Set sSheet = sBook.Worksheets("test")
sApp.Visible = True
sSheet.Cells(1, 1) = "编号"
sSheet.Cells(1, 2) = "姓名"
sSheet.Cells(1, 3) = "性别"
我想将上边的几个单元格填充上颜色并且加上边框线,应该如何操作呢?