Search results 54

Sorted from new to old.
Card image
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

Card image
NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

Card image
DB Functions (By AI)

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

Card image
HyperlinkFunction

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

Card image
SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

Card image
Shape_Select_or_CreateThenSelect

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

Card image
ANmaSQL_InsertStatement

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

Card image
DBTable2CSV

Exports table into CSV from ASP Classic function.

Card image
iframeBtn

A button in iframe, to run certain command and return status to end user ...

Card image
ANC Bootstrap controls (Testing < and & # 6 0 ;)

Testing step in site (or in each HTML output function to replace < with < ...

Card image
RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Card image
Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

Card image
InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

Card image
Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

Card image
Most recent in Oracle DB

List the most recently added rows based on a date column.

Card image
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...