Search results 21

Sorted from new to old.
Card image
BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

Card image
BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

Card image
Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

Card image
SortedFiles

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

Card image
Is64Bit

Determine if system is 64 bit or not. Related to

Card image
RmDir

Delete a folder, expects to be an empty folder, path must be already MapPathed

Card image
RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

Card image
FindFile

Finds if a workbook is open or not in same Excel session

Card image
WelcomeSheet

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

Card image
IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

Card image
FindVBAObject

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

Card image
XorC

Simple small function to Encrypt or Decrypt a string in cell Test_XorC is for ...

Card image
DeleteAllFiles

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

Card image
CanAccessVBA

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

Card image
AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

Card image
File_FirstFound

Gets first file found matches a wildcards mask, using Dir()