Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

ANmAdvancedFilter

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

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

ANmaSQL_InsertStatement

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

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

DBTables

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

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

CSVs2Sheets

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

CSVs2Sheetsv0.2.xlsb.zip

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

Execute exe embedded in Excel

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