Search results 669

Sorted from new to old.

ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

FixPath, IsThere, IsThere1 ...

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

2018Jun11

Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

2018Jun9

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9

Frequency

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

2018Jun8

Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jun7

ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

2018Jun6

Time2Real

Converts TIME code to number HH:MM to xx.xx As in 10:15 to 10.25, 13:30 to 13.5

2018Jun2

RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2

Paragraph2Line + Line2Paragraph

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

2018Jun2

Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2

StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

2018Jun2

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

DB_Setting1List + DB_Setting1List_NameValue

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

2018May31

1 2 ...38 ...41 42