Codes Required
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
SharePointURL2Path + Path2SharePointURL
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30
IsThere1_Folder
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
CreateZipFiles_7Zip
Create zip from list of files listed in List_of_Files separated by comma. The ...
2018Jul14
SetAttr
Sets an attribute to file or folder Needs to have variables defined as you see ...
2018Aug16
DirsCombo_Read
Read directories in a specified folder into a combobox Needs FrmBr having Cbo1
2018Jun18
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Frm5Textbox
Shows a text in textbox as separate window Caller can modify size of textbox, ...
2022Feb22
Highlight row of current month
Highlight row in Excel if it is within current month This is another version ...
2021Sep2
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
