|
本帖最后由 adders 于 2012-3-22 21:25 编辑
这两个自定义函数应该是在VBA中运用比较广泛的,可以设为Public Function,以便各模块的Sub调用.- Public Function FileExists(fname) As Boolean '判断该文件是否存在,是结果为True,否为False
- Dim x As String
- x = Dir(fname)
- If x <> "" Then FileExists = True
- End Function
复制代码
- Public Function IsWbOpen(wbName As String) As Boolean '判断工作簿是否打开,是结果为True,否为False
- Dim i As Long
- For i = Workbooks.Count To 1 Step -1
- If Workbooks(i).Name = wbName Then Exit For
- Next
- If i <> 0 Then IsWbOpen = True
- End Function
复制代码
Sub运用实例可参考此贴4楼: http://www.excelpx.com/thread-229928-1-1.html
|
|