Search results 62

Sorted from new to old.

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

To raise a friendly error message with option to show custom error number and ...

2018Jul7

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

2018Jul6

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

2018Jul3

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

2018Jun30

Converts SharePoint URL to regular folder path and the other way, giving the ...

2018Jun30

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

2018Jun30

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

2018Jun21

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

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

2018Jun11

Returns 1 if an item found in array, 0 if not

2018Jun6

Converts Red, Green and Blue integers into RGB long value

2018Jun2

Cuts string from a larger one based on a specific separator.

2018May29

This is the final version of my set of Setting functions SettingRead, ...

2018Apr27