Search results 245

Sorted from new to old.

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

FoldersIn5

Creates list of subfolders and subfolders of each down to 5 levels Folder ...

2018Aug8

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

2018Jul29

RandomRecords

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

2018Jul29

List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

2018Jul26

sortArray

Sort an array of Numeric values, simple straightforward Edit v3 2021-09-21: ...

2018Jul25

DB_SettingRead_Field

Returns a certain field from Settings table by a SettingName. Similar to ...

2018Jul24

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

2018Jul17

getDaysInMonth

Gets number of days in a certain month

2018Jul15

Capitalize1st

Capitalize 1st letter of a string

2018Jul15

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

1 2 ...13 ...15 16