Search results 708

Sorted from new to old.

MatchIf (aka VMatchIf)

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

2018Jun16

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

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

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14

Crypt128

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

2018Jun14

ListBox_SelectedIndexes

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

2018Jun11

GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11

GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11

FixPath, IsThere, IsThere1 ...

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

2018Jun11

Container Switcher

Using Classic ASP and cookies, allow users to personally choose between normal ...

2018Jun10

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

Multi-line Textbox focus bug

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

2018Jun7

FindIn1DArray

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

2018Jun6

1 2 ...43 44 45