Codes Required
IsThere1_SPWB
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
IsThere2
Finds a file in giving its full path Similar to IsThere1 except this one uses ...
2020Jan10
IsThere1_Image
Searches for an image and return the file extension of found, or returns null ...
2019Dec7
IsThere_Remote
Checks if a file can be reached online or no
Same as
2019Jun7
IsThere1_Folder
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Similar codes
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
FS_CreateUserFolder
Creates a folder for a user, usually after sign up or login for first time
2018Jul9
CopyFiles Excel-Macro
Simple macro to make sure we have a copy of all files in a folder found in ...
Mar12
CreateZipFiles_7Zip
Create zip from list of files listed in List_of_Files separated by comma. The ...
2018Jul14
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
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
Random Codes
ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
