|
比如我现在做的这个代码,
都是从外部工作簿中提取数据,
然后把数据放在数组中。
Public Function lastunblankrow(location, sh, col)
lastunblankrow = location.Worksheets(sh).Range(col & "65536").End(xlUp).Row
End Function
Sub getdatanotified()
Set wbnotified = GetObject("C:\Users\Administrator\Desktop\new.xls")
e = lastunblankrow(wbnotified, "sheet1", "a")
namenotified = wblicensed.Worksheets("sheet1").Range("D3:D" & e)
locnotified = wblicensed.Worksheets("sheet1").Range("c3:c" & e)
ubnamenotified = UBound(namenotified, 1)
End Sub
Sub getdatalicensed()
Set wblicensed = GetObject("C:\Users\Administrator\Desktop\批准列表.xls")
e = lastunblankrow(wblicensed, "第一页", "a")
namelicensed = wblicensed.Worksheets("第一页").Range("c3:c" & e)
serial = wblicensed.Worksheets("第一页").Range("b3:b" & e)
ubnamelicensed = UBound(namelicensed, 1)
End Sub
getdatanotified()和getdatalicensed()
两个东西,结构是很相似的。
我就是想问下有没有办法,可以像函数一样,我只要把变量输入,
它就可以自动写出结构类似的sub来?
你这里既然用X传递变量,应该做为模块级变量声明。 - Dim x
- Sub q()
- x = 1
- End Sub
- Function a(c)
- Dim d$
- d = c
- Application.Run d
- a = x
- End Function
- Sub test4()
- m = a("q")
- MsgBox m
- End Sub
复制代码
|
|