我定义的函数CALC如何在COMMAND中引用呢?Function Find(ByVal Sheet As Excel.Worksheet, ByVal Col As Long, ByVal Value) As Long
Dim i As Long
For i = Sheet.UsedRange.Rows To 1 Step -1
If Sheet.Cells(i, Col).Value = Value Then Exit For
Next
Find = i
End FunctionSub Calc(ByVal Sheet1 As Excel.Worksheet, ByVal Sheet2 As Excel.Worksheet)
Dim sIP As String
Dim i As Long
Dim j As Long
Dim k As Long
For i = 1 To Sheet2.UsedRange.Rows
sIP = Sheet2.Cells(i, 1)
k = InStr(1, sIP, ":")
If k > 1 Then
sIP = Left$(sIP, k - 1)
j = Find(Sheet1, 1, sIP)
If j > 0 Then
Sheet2.Cells(i, 3) = Sheet2.Cells(i, 2) / Sheet1.Cells(j, 2)
End If
End If
Next
End Sub
Dim i As Long
For i = Sheet.UsedRange.Rows To 1 Step -1
If Sheet.Cells(i, Col).Value = Value Then Exit For
Next
Find = i
End FunctionSub Calc(ByVal Sheet1 As Excel.Worksheet, ByVal Sheet2 As Excel.Worksheet)
Dim sIP As String
Dim i As Long
Dim j As Long
Dim k As Long
For i = 1 To Sheet2.UsedRange.Rows
sIP = Sheet2.Cells(i, 1)
k = InStr(1, sIP, ":")
If k > 1 Then
sIP = Left$(sIP, k - 1)
j = Find(Sheet1, 1, sIP)
If j > 0 Then
Sheet2.Cells(i, 3) = Sheet2.Cells(i, 2) / Sheet1.Cells(j, 2)
End If
End If
Next
End Sub
解决方案 »
- 如何展开treeview所有节点呢?TVW.Nodes(1).Expanded = True 只能展开根节点呀?
- 有没有能增强RS-232串口驱动能力的小设备
- 11个textbox,依次输入的问题,请指教!
- vb中使用webbrowser以后,如何向webbrowser中的各个html元素赋值?
- VB6中如何设计和打印报表
- 有关三维
- 高分求软件开发文档(作为毕业论文的范本)
- 关于窗体事件的问题,高手请进.
- 关于DataGrid及ComBox的几个问题?
- 200分白送,谁要?
- 软件开发中遇到datagrid控件相关问题~请兄弟们帮帮忙~
- VB中 在TEST1(0) TEST1(1)....TEST1(17)中分别输入 要求在RichTextBox1中显示
参考我写的下面这个7楼:
http://topic.csdn.net/u/20080127/16/2a102bc7-ea5d-4f5a-b962-4da424407fdf.html
Dim xlapp1 As Excel.Application
Dim xlbook1 As Excel.Workbook
Dim xlsheet1 As Excel.Worksheet Dim xlapp2 As Excel.Application
Dim xlbook2 As Excel.Workbook
Dim xlsheet2 As Excel.Worksheet Set xlapp1 = CreateObject("Excel.Application")
Set xlapp2 = CreateObject("Excel.Application") Set xlbook1 = xlapp1.Workbooks.Open("c:\book1.xls")
Set xlbook2 = xlapp2.Workbooks.Open("c:\book2.xls") Set xlsheet1 = xlbook1.Worksheets(1)
Set xlsheet2 = xlbook2.Worksheets(1) Call Calc(xlsheet1, xlsheet2) xlapp2.Quit
Set xlapp2 = Nothing
xlapp1.Quit
Set xlapp1 = NothingEnd Sub