Codes Required
SendEmailMsgv2023
Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...
Nov12
ANmaNumber_Closest2Word
Finds the number between two spaces that is found close to of Word1Location ...
Oct24
WordPress - Excel functions (AI)
3 functions to download posts, adds new post and to upload and set featured ...
2023Apr22
ScrapeURL_ToSheet
Reads content of Page from URL to a sheet. This was made specially for certain ...
2023Apr4
NavigatePost
Reads content of webpage with optional post data
two main differences from
2023Jan14
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
ANmaDB functions
Database functions, commonly used in my systems. Should be working for each ...
2019Apr14
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
WorkbookClose_ANmar
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
Posts_per_Year
Gets list of years and total of posts per year from a table, by using date ...
2018Jul29
oShellRun1
Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...
2018Jul6
CellHyperlink_ToSheet
Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...
2018Jun24
DosCommand_Read
Get output of DOS Command in string, by reading output into temp text file, ...
2018Jun22
OpenPassword + ClosePassword
Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...
2018Jun14
Similar codes
VHD file 7GB - Delete
VHD file, 7GB, helpful when you want to quickly save files into an 8 GB usb ...
2018Nov8
FolderSize_Swift
Gets total of folder size in bytes. With some tweaks, you can modify it to use ...
2020Apr20
ImagesIn_Count
Counts number of image files found in a folder Images defined here are files ...
2018Nov25
.png)
ANmaBrowser v20.19.01
Single file, Classic ASP, Bootstrap 4.1 and FontAwesome 5.0 file manager. ...
2018Sep19
DiskDriveType
Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...
2022Aug17
GetRelativePath
Get relative path of one to another Pass two path strings to this function and ...
2018Jul19
ProtectFile_XorD + UnProtectFile_XorD
Protects and unprotects a file using password Creates another copy of the file ...
2020Jan10
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
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
Gototop + Circular scroll progress
JS icon to show progress of scroll in webpage having button to go back to top. ...
Jan28
bootstrap-linkpreview
Preview link js script uses jquery and bootstrap
From
Nov3
