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
)