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
BrowseWorkbook + BrowseWorkbook_Save
Asks for Excel file to open, then return the full filename with path if ...
2018Jun16
Toggle navbar with Slide Down Animation
TOggle Navbar to show, login form, another list of links, search bar, or ...
2020Jul30
Filename_Clean
Returns cleaned file name of invalid characters. Needs to be modified if used ...
2023Jan11
CutString_Words_Left + CutString_Words_Mid
Cuts the left or Middle part of string without breaking words Can specify ...
2018Aug8
Vertical page breaks
Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...
2021Feb24
UnBreakAr + BreakAr
Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...
2018Jul25
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
HTMLTagID_Previous
Return id for any html tag that was found above certain location of html page. ...
Feb2
SQL Related posts
Steps to create related posts query in SQL. Index, catalog, matching posts for ...
2022Jul6
HeadingZeros Remove and Add
Adds or remove zeros at start of string Used to clear heading zeros from ...
2019May31