Search results 36

Sorted from new to old.

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Cookies usage prompt

Bootstrap 4 cookies prompt for GDPR From

2019Jun19

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

INITool

INITool Object allows an ASP programmer to work with INI files on the server. ...

2018Aug25

Page area and Page Setup functions (Unfinished)

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

2018Jun30

DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30

LogSheet_Add + LogSheet_Clear

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

2018Jun24

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

1 2 3