Search results 62

Sorted from new to old.

Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

2025Oct11

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

2025Feb26

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

2024Apr30

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

Excel user name

Get application user name or change it Originally from

2023Jun14

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

Auth_User

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

2020Feb23

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

1 2 3 4