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
ShowThumb
ASP.Net ShowThumb.aspx file that generates image thumb from an image, official ...
2018Sep19
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
ContainerHTMLTag_ReturnBlock
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
SettingRead_JSON
Reads certain value for a certain setting from FullJSONString text block. See ...
Jan8
ANBSThumbImg + ANBSThumbLink
Creates thumb of an image with or without link to original Use ANBSThumbLink ...
2019Dec1
Limit Characters in a TextArea
This will limit the number of characters a user types in a textarea.
2018Apr18