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
FA5Icon_FromExt
Gets FontAwesome 5 icon for a file using its extension Used in MyDev website
2018May12
FileDateTime
Gets time and date for a file, Date created, accessed or modified. If the file ...
2018Jul5
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
OST Outlook file location
Outlook OST (and PST) files to be saved in different location Instruction can ...
2022May12
Uploader Widget
jQuery Ajax File Uploader Widget Promising, need to start implementing it in ...
2019Jun28
