Codes Required
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
ChartLabelsNumberFormat
Apply Number format of 1 decimal to datalabels of specific series in certain ...
Dec23
ChartLegendCenter
Put chart legend at center of chart horizontally. Changes left and width only. ...
Dec21
ANStrFind_AndOrAdd
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
PrCal_Add_Sort
Adds to daily log, two cells, one with date, next with activity that will be ...
Dec2
ReplaceChars
Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...
2018May26
FileSize_Formatted
Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...
2018Apr25
FileDate_Formatted
Returns a formatted version of file 'LastModified' date. Pass parameter ...
2018Apr25
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
RemoteExplorer.asp
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
GetRandom
Generate random string, fully customization, with even deciding what special ...
2018Apr21
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
DB_SettingRead + DB_SettingSave + ...
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Similar codes
SettingRead_JR
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
File_SettingRead + File_SettingSave
Reads and saves settings to Settings file, used asp here.
Similar to
2022Dec27
DB_SettingRead_Field
Returns a certain field from Settings table by a SettingName. Similar to ...
2018Jul24
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
DB_SettingRead + DB_SettingSave + ...
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
SettingNameAlreadyFound
Searches for a setting value in set of Settings, in Excel spreadsheet using ...
2022Aug18
SettingRead+SettingSave
This is the final version of my set of Setting functions SettingRead, ...
2018Apr27
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Range22DimArray
Imports a range into 2-dimension array. Returns the array, providing range, ...
May11
User-defined type error
How to fix error (User-defined Type) error, especially when using outside ...
2019Feb1
FixENTERS_File
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7
Col2Combo
Reads everything in a column (starting from certain cell until blank cell is ...
2018Jun10