Search results 36

Sorted from new to old.

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

Aug11

FindZipFile_WShell

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

Aug2

CutString96_NumberX

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

Aug2

ANstr_Column

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

Jul29

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

Jul28

Quarter1stLastDate_FromQuarterText

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

Jul26

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Feb25

VLookup_HTML

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

Jan26

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

1 2 3