Private Sub Command2_Click()
Dim AAA As Object
Dim BBB As Object
Dim CCC As Object
Dim DDD As ObjectSet AAA = CreateObject("excel.application")
AAA.Visible = TrueSet BBB = AAA.Workbooks.Open("J:\H\L.xls")
Set CCC = BBB.worksheets(1)
CCC.Activate
Set DDD = BBB.worksheets(2)
DDD.ActivateDim i, j As Integer
i = 6
For j = 5 To 27
i = 6
Do While (i <= 115)
If CCC.cells(i, 6) = DDD.cells(j, 8) Then
CCC.cells(i, 7) = DDD.cells(j, 7)
ElseIf Len(DDD.cells(j, 7).Value) = 0 Then
CCC.cells(i, 7).Value = CCC.cells(i, 6).Value
CCC.cells(i, 7).Interior.Color = RGB(255, 0, 0)
End If
i = i + 1
Loop
Next j
End Sub
Dim AAA As Object
Dim BBB As Object
Dim CCC As Object
Dim DDD As ObjectSet AAA = CreateObject("excel.application")
AAA.Visible = TrueSet BBB = AAA.Workbooks.Open("J:\H\L.xls")
Set CCC = BBB.worksheets(1)
CCC.Activate
Set DDD = BBB.worksheets(2)
DDD.ActivateDim i, j As Integer
i = 6
For j = 5 To 27
i = 6
Do While (i <= 115)
If CCC.cells(i, 6) = DDD.cells(j, 8) Then
CCC.cells(i, 7) = DDD.cells(j, 7)
ElseIf Len(DDD.cells(j, 7).Value) = 0 Then
CCC.cells(i, 7).Value = CCC.cells(i, 6).Value
CCC.cells(i, 7).Interior.Color = RGB(255, 0, 0)
End If
i = i + 1
Loop
Next j
End Sub
解决方案 »
- 请教单片机通信中时vb控件mscomm的使用
- 请教第一个最简单的VB程序就出错
- 我使用activereport 打印时总会在末端打出它的版本号和其他信息,怎么取消掉阿?
- 有关StrConv(InputB(LOF(1), 1), vbUnicode), 文件操作
- 如何对数据库中的记录按顺序自动进行编号,如有10条记录,删除第二条记录,自动编号为1-9,这怎么实现?
- vb.net 如何修改txt文件内的数据。
- 急!菜鸟求救。vb+access。ole对象字段读写
- 怎么不能动态添加控件?
- 这三个控件有什么区别?
- 装完real后工程库中的real控件只能放声音不能视频
- 自由落体位移公式编程
- 编程项目寻求VB高手兼职(限北京),急!
CCC.cells(i, 6) <> DDD.cells(j, 8) and Len(DDD.cells(j, 7).Value) = 0
Private Sub Command2_Click()
Dim AAA As Object
Dim BBB As Object
Dim CCC As Object
Dim DDD As Object Set AAA = CreateObject("excel.application")
AAA.Visible = True Set BBB = AAA.Workbooks.Open("J:\H\L.xls")
Set CCC = BBB.worksheets(1)
CCC.Activate
Set DDD = BBB.worksheets(2)
DDD.Activate Dim i, j As Integer
i = 6
For j = 5 To 27
i = 6
Do While (i <= 115)
If CCC.cells(i, 6) = DDD.cells(j, 8) Then
CCC.cells(i, 7) = DDD.cells(j, 7)
ElseIf Len(DDD.cells(j, 7).Value) = 0 Then
CCC.cells(i, 7).Value = CCC.cells(i, 6).Value
CCC.cells(i, 7).Interior.Color = RGB(255, 0, 0) '设置第七列为红色
End If
i = i + 1
Loop
Next j
End Sub