[VBA][Excel][Function] 確認磁碟區是否存在

2009-06-05

6412
0
VBA
2009-06-08

摘要:[VBA] 確認磁碟區是否存在

'Description：確認磁碟區是否存在 'Parameters：strDrive 磁區代號 ex. "C","D"... 'Retrun：Boolean 'Package： 'Reference：Microsoft Scripting Runtime 'Creater：Darren.NET - 2009/04/20 - Ver. 1.00 'Modify： Public Function F_Drive_isDrive(strDrive As String) As Boolean Dim fsoDrive As Scripting.FileSystemObject Set fsoDrive = New Scripting.FileSystemObject F_Drive_isDrive = fsoDrive.DriveExists(strDrive) End Function

VBA Excel Function

回首頁