ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

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 ...

DBTable2CSV

Exports table into CSV from ASP Classic function.

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

Hide SQL table

A simple easy way to hide tables in SQL Server

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

CSVs2Sheetsv0.2.xlsb.zip

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one