Codes Required
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Similar codes
WorkbookOpenAsk_ANmar
Asks user to browse to a file and return full path and file name if they do, ...
2018Jul17
DownloadFile_User
Downloads file to user, asking user where to save or to open downloaded file
2018Jun30
Open different Filestypes
Populate list of filetypes in Application.GetOpenFilename method. This command ...
2019Jan9
Filename_Clean
Returns cleaned file name of invalid characters. Needs to be modified if used ...
2023Jan11
ANmaPivotTable_Clear
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
ImagesIn_Count
Counts number of image files found in a folder Images defined here are files ...
2018Nov25
CreateZipFiles_7Zip
Create zip from list of files listed in List_of_Files separated by comma. The ...
2018Jul14
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
Recently by developer
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Random Codes
Multi-Level BS4 menu
Another Multi-level menu, this one in Bootstrap 4 and is activated by clicks ...
2020Aug13
Dropdown text field
Drop down text field, need it in one of my projects. Even though I will need ...
2019Jun25
SetAttr
Sets an attribute to file or folder Needs to have variables defined as you see ...
2018Aug16