Codes Required
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
CreateThumbSquare_IrfanView
Creates square thumb for an image, regardless of image aspect ratio It will ...
Jan18
Protect txt file into word doc with password
Saves txt file as word doc with password. Passing txtfile having full path and ...
Jan4
ANStrFind_AndOrAdd
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
WordPress - Excel functions (AI)
3 functions to download posts, adds new post and to upload and set featured ...
2023Apr22
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
UISetup + UIRestore
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
Styles_DeleteNonStandard
Delete styles from an Excel workbook, any non-standard style will be deleted. ...
2018Aug12
RandomImage
Gets a random image from a folder of files, passed as an unMapPathed (HTML) ...
2018Aug10
RandomRecords
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
Cookies warning
Thanks to new law in Europe, we need to show users and let them accept a ...
2018Jul6
GetRandom
Generate random string, fully customization, with even deciding what special ...
2018Apr21
Similar codes
ScrapeURL_ToSheet
Reads content of Page from URL to a sheet. This was made specially for certain ...
2023Apr4
Bootstrap IE issue
Looks like IE has some issues in bootstrap 3, this is the solution, please ...
2019Jan11
HTMLTagID_Previous
Return id for any html tag that was found above certain location of html page. ...
Feb2
Shortcut website
Create a shortcut to website to open using Internet Explorer in 'InPrivate' ...
2020Jan22
NavigatePost
Reads content of webpage with optional post data
two main differences from
2023Jan14
ANC Bootstrap controls (Testing < and & # 6 0 ;)
Testing step in site (or in each HTML output function to replace < with < ...
2021Jun9
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
Random Codes
ReplaceStrings
Replace strings found in list of strings from inside a string, does taht make ...
Nov11
Detect if Browser supports Flash
Detect if Browser supports Flash or not ( using ShockwaveFlash.ShockwaveFlash) ...
2019Jun2
ExcelMenu_onfly
Creates Excel menu on the fly, list of menu items, command actions, and icons ...
2018Jul17
Cookies warning
Thanks to new law in Europe, we need to show users and let them accept a ...
2018Jul6