Search results 114

Card image cap
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image cap
ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

Card image cap
SQL Related posts

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

Card image cap
ANmaSQL_UpdateDateStatement

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

Card image cap
ANmaSQL_InsertStatement

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

Card image cap
DBTable2CSV

Exports table into CSV from ASP Classic function.

Card image cap
DBTables

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

Card image cap
Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

Card image cap
CSVs2Sheets

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

CSVs2Sheetsv0.2.xlsb.zip

Card image cap
ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

Card image cap
SumOf_3Filters

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

Card image cap
EnvironList

List of all variables of Environ It will populate them in sheet range starting ...