Codes Required

code image
HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

Aug4

code image
StartApp-IfNotStarted

Checks if application is already running, returns 1 or 0 My first function

Aug3

code image
CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

Aug2

code image
FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

Jul31

code image
ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30

code image
ANstr_Column

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

Jul29

code image
Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

Jul26

code image
QuarterNumber_FromDate

Returns the number of quarter from a date

Jul26

code image
JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

code image
ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

code image
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

May16

code image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

code image
Files_FoundHours

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

Apr30

code image
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

code image
SettingSave + SettingRead for NumberFormat

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

Apr19

code image
CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

code image
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Apr3

code image
Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Mar23

code image
HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Feb28

code image
CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

Feb27

Similar codes

code image
TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

code image
Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

code image
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

code image
GetWordCount

Counts how many words found inside a string. Using space, tab or enter as ...

2019Mar31

code image
Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

2019Feb8

code image
Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

code image
UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

Nov28

code image
DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

code image
Prn

Printout into page, along with additional function to decide where to put the ...

2018Aug5

Recently by developer

code image
ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

Thu 11AM

code image
JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

Tue 12PM

code image
GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

Sat 11AM

code image
HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

Sat 11AM

Random Codes

code image
ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Apr15

code image
MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

Jan13

code image
Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

code image
WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9