Search results 85

Sorted from new to old.

Weighted_Average

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

2018Jul7

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6

strUnQuote

This will tests to see if strQuotedString is wrapped in quotation marks, and, ...

2018Jul3

DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

2018Jun30

FormulasFlatten

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

2018Jun30

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

UTF8R_toChar

Converts characters created by program R into actual chars as in < U+641 > to ...

2018Jun26

WeekNum

Generates the calendar week number for a certain date, counting the first week ...

2018Jun26

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

2018Jun22

ASCII_Read + ASCII_Save

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

2018Jun21

confirmDelete

Asks user before running a link (mostly before deleting) Small important part ...

2018Jun19

RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17

WorkbookOpen_ANmar

Opens Workbook in the background with no flickering and with options of ... ...

2018Jun16

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

2018Jun2

1 2 ...5 6