Search results 149

Sorted from new to old.

Daily folder

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

2024Jul28

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

2024Apr23

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

2024Mar5

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

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

2024Feb28

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

Steps Recorder Win10 app

Win10 application already found in Windows. to generate list of steps with ...

2024Feb16

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

1 2 ...9 10