Codes Required

Similar codes

code image
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

code image
all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

2019Dec22

code image
ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

Dec4

code image
FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

code image
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

code image
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

code image
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

code image
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

code image
ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

Jul29

Recently by developer

code image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

code image
Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

code image
PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

code image
TrimLines

Remove all line breaks from text from a text. Not like

Jan31

Random Codes

code image
MouseDown and MouseUp in FM20 controls

MouseDown and MouseUp in VBA (fm20 controls) are different from those in VB6 ...

2019Apr14

code image
ANma_HTML2DB + ANma_DB2HTML + ...

Convert HTML text into DB-safe string, by converting some characters as below. ...

2019Feb7

code image
ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

2018Jun24

code image
Rename File

This will rename a specific file and or move the file to a different directory

2018Apr16