Search results 22

Sorted from new to old.

BusinessDateAdd

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

2023Oct11

BooleanCount

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

2022Apr22

Old cell value

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

2021Dec30

Frm6 - ANmaMultiSelect

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

2021Jun23

SortedFiles

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

2020Aug11

Is64Bit

Determine if system is 64 bit or not. Related to

2020Feb7

PrettyPath

Formats a path for use in user displays, trim it beautifully. PrettyPath is ...

2018Sep23

RunFromShared

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

2018Aug9

FindFile

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

2018Jul11

WelcomeSheet

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

2018Jul9

IIF

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

2018Jul7

FindVBAObject

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

2018Jul6

XorC

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

2018Jul1

DeleteAllFiles

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

2018Jun30

CanAccessVBA

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

2018Jun22

AreTheyTheSame

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

2018Jun20

1 2