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
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
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
BrowserSetting
Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...
2022Apr29
Import error log
Imports the SQL Server error log into a table, so that it can be queried This ...
2018Sep29