Search results 583

Sorted from new to old.

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16

GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

FixPath, IsThere, IsThere1 ...

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

2018Jun11

Modify SQL table

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

2018Jun9

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6

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

RemoveHTML

Removes HTML code Basically all tags expected and listed below There is a ...

2018May26

ANmaHTMLTemplate

Index.html template having headers with Bootstrap v4.1 and Font-Awesome (BS4.1 ...

2018May22

FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

2018May22

Shareware software window (Frm4)

Show Shareware software
How to use it:
Frm4.ShowMe
Or
Frm4. ...

2018May16

1 2 ...36 37