ファイル
存在確認
Public Function FileExists(FileSpec As String) As Boolean
Dim bRes As Boolean
Dim FSO As FileSystemObject
Set FSO = New FileSystemObject
bRes = FSO.FileExists(FileSpec)
Set FSO = Nothing
FileExists = bRes
End Function
移動
削除
Public Sub DeleteFile( _
sFileSpec As String, _
Optional bForce As Boolean = False _
)
Dim FSO As FileSystemObject
Set FSO = New FileSystemObject
Call FSO.DeleteFile(sFileSpec, bForce)
Set FSO = Nothing
End Sub
ファイル名 取得
Public Function GetFileName(Path As String) As String
Dim sRes As String
Dim FSO As FileSystemObject
Set FSO = New FileSystemObject
sRes = FSO.GetFileName(Path)
Set FSO = Nothing
GetFileName = sRes
End Function
ファイル名(拡張子なし) 取得
拡張子 取得
コピー
'**
'* 【 File 】
'* コピー:CopyFile
'*
'* Sub CopyFile(
'* Source As String,
'* Destination As String,
'* [OverWriteFiles As Boolean = True]
'* )
'*
'* @param {}
'* @param_ref {}
'* @return {}
'*
'* @note
'* ワイルドカード使用可
'*
Public Sub CopyFile( _
sSource As String, _
sDestination As String, _
Optional bOverWriteFiles As Boolean = True _
)
Dim FSO As FileSystemObject
Set FSO = New FileSystemObject
Call FSO.CopyFile( _
sSource, _
sDestination, _
bOverWriteFiles _
)
Set FSO = Nothing
End Sub
フォルダ
【 参考 】
FileSystemObject