Search results 88

Sorted from new to old.

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2

DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31

CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...

2018May29

CutString3

Cuts string from a larger one based on a specific separator.

2018May29

CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...

2018May29

1 2 ...5 6