Search results 567

Sorted from new to old.

SortedFiles

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

2020Aug11

Sorting Strings

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

2020Jul22

Functions.dll

Old DLL housing list of functions to be used and called by any application, ...

2020Jul18

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

FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20

DelFiles

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

2020Apr1

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Remove_Between2Quotes

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

2020Mar9

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

Capitalize in JS

Convert text to all capital letters

2020Feb16

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

1 2 ...17 ...35 36