Codes Required
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
NavigatePost
Reads content of webpage with optional post data
two main differences from
2023Jan14
File_SettingRead + File_SettingSave
Reads and saves settings to Settings file, used asp here.
Similar to
2022Dec27
Navigate_IE
Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...
2021May31
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
File_SettingRead + File_SettingSave
Reads and saves settings to Settings file, used asp here.
Similar to
2022Dec27
CellSave and CellRead
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
SettingRead_JR
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
DB_Setting2Read + DB_Setting2Save
Reads and save setting into settings table per 2 IDs, similar to SettingRead ...
2018May31
LstCustomSelection_Refresh
Read list of items from Settings sheet, then Sort, then save, before reading ...
2022Aug31
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
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
Random Codes
NavigatePost
Reads content of webpage with optional post data
two main differences from
2023Jan14
Part of cells in Excel
How to modify part of text inside an Excel cell using VBA. Something in my ...
2020Oct13
Prevent Submit until reCaptcha
Disable Submit button until Google reCaptcha is verified, used reCaptcha v2.0 ...
2018Dec20