Codes Required

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

Card image cap
File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

Card image cap
Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

2021May31

Card image cap
Navigate

Downloads a certain page source into a variable, full content in HTML, using ...

2018May22

Card image cap
SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

2018Apr27

Card image cap
DB_SettingRead + DB_SettingSave + ...

Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...

2018Apr14

Similar codes

Card image cap
File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

Card image cap
CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

Card image cap
Navigate

Downloads a certain page source into a variable, full content in HTML, using ...

2018May22

Card image cap
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
GetConfigValue

Read settings from Web.config file (or other XML files) Originally from ...

2018Aug5

Card image cap
DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

2018May31

Card image cap
LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

Card image cap
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

Random Codes

Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Card image cap
FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20

Card image cap
jExcel

jQuery plugin to embed a spreadsheet, compatible with Excel, in your browser. ...

2019Oct3

Card image cap
getQueryString

Reading QueryString from JS

2018May29