Search results 243

Sorted from new to old.

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

TrimEnters

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

2020Sep19

RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7

URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

2020Aug21

ReadHTMLTag

Reads string between open and close HTML tag (between < ... > and < / ... >), ...

2020Aug15

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...

2020Jul22

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

DB_Connect_Install

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

2020Mar24

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

1 2 ...9 ...15 16