Search results 107

Sorted from new to old.

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

Sun 2PM

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

2024Sep16

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

2024Aug21

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

SqlExec

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

2023Sep3

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

1 2 ...6 7