Search results 122

Sorted from new to old.

BusinessDateAdd

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

2023Oct11

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

1 2 3 ...7 8