Search results 67

DB Connection Drivers Test
Test connection to DB using different drivers to see which one works. You may ...

CutString_ANmaRules
Extract certain text from another text based on Rules defined, like extracting ...

ANmaRemoveDuplicates2
Remove duplicated rows based on 2 columns in a table of any number of columns. ...

ANmaRemoveDuplicates4
Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

ConditionalFormatting_ColorARow
Adds conditional formatting to color a row in table based on output of formula ...

Font-Based progress bar
Show progress bar using fonts only. Neat trick to use inside HTML or word ...

ANmaRead_1stFile
Returns information about first file name found after sorting matching files in ...

Triangular coded msg in file
Decodes message from file based on number in each line of text. Attached ...

SQL Cross Apply String_Split with XML Path
SQL select statement to convert list of IDs found in column (from more than row ...

HTMLPadding_or_Margin
Finds the padding or margin from a style statement for an HTML tag. Passing ...

WorkbookSave_ANmar
Saves a workbook handling several scenarios and decide what to do based on each. ...