ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

JsBarcode

Generate barcode in js Tested and works better than others

JsBarcode.zip

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...