Search results 346

Sorted from new to old.

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

Cookies warning

Thanks to new law in Europe, we need to show users and let them accept a ...

2018Jul6

Active BS4 breakpoint

Was looking for some way to show bootstrap 4 breakpoint, and got this

2018Jul6

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Sort1Col

Sorts a column in Excel, easily, with options

2018Jul4

strUnQuote

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

2018Jul3

Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

2018Jul3

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

DelOldFiles

Delete files in a specified folder which are older than x days This code ...

2018Jun24

GetPapa

Gets folder name of a page using FSO

2018Jun24

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

2018Jun24

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

1 2 ...19 ...21 22