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
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
OneDrive Reset
Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...
Mar5
IsThere1_Folder
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
WorkbookOpenAsk_ANmar
Asks user to browse to a file and return full path and file name if they do, ...
2018Jul17
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
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
SwapNumbers
Swap two numbers variables without using third variable A trick worth saving ...
2022Oct17
ServerXMLHTTP stream
Using ServerXMLHTTP object to show (stream or download) and image , or any ...
2021Aug3
Functions.dll
Old DLL housing list of functions to be used and called by any application, ...
2020Jul18
Webapp-ScrollAreas
Allow website to have scroll bars on areas, like a web app Applied in ANmar. ...
2018May19