Search results 119

Sorted from new to old.

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

SQL Date from DateTime

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

2023Nov29

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

SubZero

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

2023May23

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

2023Apr3

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

ASPUsers

Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...

2022May4

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

Old cell value

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

2021Dec30

1 2 ...7 8