Search results 118

Sorted from new to old.

DB Connection Drivers Test

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

Mar12

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

2024Feb15

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

2024Jan31

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

2024Jan14

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

2024Jan6

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

SQL Date from DateTime

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

2023Nov29

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

ReplaceStrings

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

2023Nov11

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

1 2 ...7 8