Search results 48

Sorted from new to old.

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

2025Sep30

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

2025Jul27

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

2024Nov7

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

2024Feb9

SQL Cross Apply String_Split with XML Path

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

2024Jan20

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

2023Nov10

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

1 2 3