In this section you can find VBA functions and subroutines to operate on system resources, like files, folders or Windows settings.
The functions are listed below:
- Function to check the file extension from a given filepath (
getFileExtension)
- Function to return the file name and file extension from the given path (
getFileName)
- Function to create and return the reference to the given folder (
createFolder)
- Function to check if it is possible to write data into the specified textfile (
isTextfileWriteable)
- Function to delete the specified file from the file system (
deleteFile)
- Function to delete the specified folder from the file system (
deleteFolder)
- Function transforms the given filepath so that it is unique in the file system (
uniqueFilePath)
- Function transforms the given folder name so that it is unique in its parent folder (
uniqueFolderName)
- Function to check if the current user has the rights to add subfolders to the specified folder (
isSubfoldersAddingAllowed)
- Function to check if the current user has the rights to add, delete and modify files in the specified folder (
isFolderWriteable)
- Function to return the path of the folder parental for the given path (
getParentFolder)
- Function displaying pop-up to select files (
selectFile)
- Function to get the path to the Desktop folder (
getDesktopPath)
- Function to create UUID (unique ID) (
createUUID)
- Function to check if a file with the given filepath exists (
fileExists)
getFileExtension)getFileName)createFolder)isTextfileWriteable)deleteFile)deleteFolder)uniqueFilePath)uniqueFolderName)isSubfoldersAddingAllowed)isFolderWriteable)getParentFolder)selectFile)getDesktopPath)createUUID)fileExists)