Search results 101

  2. Search results
  3. 10
Sorted from new to old.
Card image
RandomRecords

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

2018Jul29
Card image
ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

2018Jul26
Card image
ProtectText + UnProtectText

Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...

2018Jul19
Card image
getDaysInMonth

Gets number of days in a certain month

2018Jul15
Card image
Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9
Card image
Weighted_Average

Does a weighted average, knowing that mathematical average between two numbers ...

2018Jul7
Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30
Card image
RandomNumber

Generate random number between Lower and upper numbers provided

2018Jun28
Card image
NumberTextArabic

Adds Arabic unit to a number using proper Arabic grammar Units can be ...

2018Jun24
Card image
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

2018Jun21
Card image
BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16
Card image
OpenPassword + ClosePassword

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

2018Jun14
Card image
FixPath, IsThere, IsThere1 ...

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

2018Jun11
Card image
Time2Real

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

2018Jun2
Card image
CutLeft

Cuts the left part respecting words, without cutting words

2018May30
Card image
Number_Formatted

Format the number as ' <1000 = 1,2,55, 85, 989 ' <1000000 = 1K, ...

2018May26
12...67