- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
¬Û¹ï²³æ¤èªk¡G
Sub ÀË´úÀɮ׶}±Ò()
If TestBookOpen("abc.xls") = "" Then MsgBox "ÀÉ®×¥¼¶}±Ò"
End Sub
ÂŦâ¦r§ï¦¨nÀË´úªº¡eÀɦW.°ÆÀɦW¡f
¼Ò²Õ¤º¦@¥Î¦Ûq¨ç¼Æ¡G
Function TestBookOpen(BookName$) As String
On Error Resume Next
TestBookOpen = Workbooks(BookName).Name
End Function |
|