Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Asks user to browse to a file and return full path and file name if they do, ...
2018Jul17
Downloads file to user, asking user where to save or to open downloaded file
2018Jun30
Populate list of filetypes in Application.GetOpenFilename method. This command ...
2019Jan9
Returns cleaned file name of invalid characters. Needs to be modified if used ...
2023Jan11
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
Counts number of image files found in a folder Images defined here are files ...
2018Nov25
Create zip from list of files listed in List_of_Files separated by comma. The ...
2018Jul14
Returns list of files found in a folder, list separated with custom separator ...
2018May22
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime
2018Jun30
Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...
2018Jun17
This script uses WSH to open an executable and save the results to a textfile.
2018Apr16