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
GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_
Gets that parent folder name giving a full path, or gets the child folder, Can ...
2018May22
Similar codes
WorkbookClose_ANmar
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
DownloadFile_User
Downloads file to user, asking user where to save or to open downloaded file
2018Jun30
IsThere1_SPWB
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
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
draggable grid
Nice gallery (or grid) that can be dragged to browse through
From
2019Oct24
fnGenerateRandomString
SQL function to generate random string I thought it would be easier to find ...
2019May5
percircle ProgressCircle
A neat progress circle (progressbar) using CSS and JQuery Used in this ...
2019Jan20
SendEmail_CDO
Sending an email using CDO object Can pass all needed variables including mail ...
2018Nov24