Codes Required
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Triangular coded msg in file
Decodes message from file based on number in each line of text. Attached ...
Mar4
IsThere1_SPWB
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
Decode and NVL
Two oracle SQL functions, that are interesting. Decode to work as (Select ...
2020Feb7
IsThere2
Finds a file in giving its full path Similar to IsThere1 except this one uses ...
2020Jan10
IsThere1_Image
Searches for an image and return the file extension of found, or returns null ...
2019Dec7
ANBS Controls Set3
3rd set of ANBS controls, Get Set1 here and
2019Dec5
HTMLDecode + HTMLEncode
Decode and encode back a string using HTML Technically found online, but ...
2019Aug9
IsThere_Remote
Checks if a file can be reached online or no
Same as
2019Jun7
IsValidUTF8 + DecodeUTF8 + EncodeUTF8
Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...
2018Sep5
IsThere1_Folder
Checks if a folder is found or not, can pass either mapped path or unmapped ...
2018Aug10
Base64encode + Base64decode
Encodes and decodes a string, Base64 is used to convert binary data (like ...
2018Jul31
SettingRead+SettingSave
This is the final version of my set of Setting functions SettingRead, ...
2018Apr27
DB_SettingRead + DB_SettingSave + ...
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Similar codes
Install/Uninstall SQLNativeClient DB driver
Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...
Feb8
NextID_Reset
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Records Affected by Execute command
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
DB_ExtendedProperties
Returns extended properties of a database, knowing the ADODB connection
2019Jul22
List of Databases
Script to list databases available in a server using ADODB connection
From
2019Oct6
DB_Setting2Read + DB_Setting2Save
Reads and save setting into settings table per 2 IDs, similar to SettingRead ...
2018May31
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
OpenOffice Calc
OpenOffice programming with Visual Basic Some document I had for my reference.
2019Jan5
Thumbnail on fly
An aspx tool to generate thumbnail from an image, used to make page load faster ...
2018Aug10
CreateThumb_IrfanView
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14