Search results 718

Sorted from new to old.

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11

UI_2ValidationsUpdate

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

2020May27

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Auth_User

Find the user name (and domain) for logged in user for in an internal intranet ...

2020Feb23

ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

2020Feb16

Capitalize in JS

Convert text to all capital letters

2020Feb16

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

1 2 ...26 ...44 45