CharsOnlyIn(StringToCheck, ApprovedCharacters) As Boolean
Quickly check all the characters in a string are in a list of approved characters. Can be used as a part of your data verification and cleansing processes.
BrowseFolder(StartFolder, WindowTitle) As String
Utilise Windows dialog forms to browse for a folder. Set the starting folder (optional) and the windows title (optional) and the browsed for folder will be returned as a string. Or a blank sting will be returned if a valid folder is not chosen.
DoesFolderExist(FolderPath) As Boolean
Before processing the documents of a folder, check it exists first. You can also pass it the path to a file and it will confirm the folder it is in exists.
BrowseFile(StartFolder, FileType, WindowTitle) As String
Utilise Windows dialog forms to browse for a file. Set the starting folder (optional), file type (optional) and the windows title (optional). The browsed for file will be returned as a string. Or a blank sting will be returned if a valid file is not chosen.
DoesFileExist(FilePath) As Boolean
Before processing the contents of a file, check it exists first. It can be used to check any file and any file type and will return a boolean value.
ColLetToNum(ColumnLetter) As Integer
Convert column letter(s) to integers to make converting between range and cell references easier. Returns a 0 if the letter(s) can’t be converted to a numbers.
ColNumToLet(ColumnNumber) As String
Convert column numbers to letters to make converting between range and cell references easier. Returns an empty string if the number can’t be converted.