create text file – Useful code

VBA – Folders and Files Functions

By Vitosh Posted on November 11, 2020 Posted in VBA \ Excel Tagged with check if folder is empty, create text file, delete all files from folder, VBA

Check if folder is empty: Public Function FolderIsEmpty(myPath As String) As Boolean FolderIsEmpty = CBool(Dir(myPath & “*.*”) = “”) End Function Delete all files in a folder: Public Sub DeleteAllFiles(path As String) Kill path & “*.*” End Sub Create text …

VBA – Folders and Files Functions Read more »

Tag: create text file

VBA – Folders and Files Functions