Search results 147

Sorted from new to old.

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

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5

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

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Filename_Clean

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

2023Jan11

OutlookFolder_DuplicatesRemove

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

2023Jan1

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

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

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

AutoSaveOn

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

2022Feb23

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

1 2 ...9 10