Search results 327

Sorted from new to old.

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

Quarter_to_Words

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

2020Dec17

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

CellSave and CellRead

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

2020Oct31

ANStrSort2

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

2020Sep24

TrimEnters

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

2020Sep19

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

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11

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

DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1

1 2 ...11 ...20 21