Search results 133

Sorted from new to old.

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

May27

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

May4

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

2024Aug15

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

ExtractNumeric_FromCell

Returns the number from an HTML cell after cleaning and finding sign. We faced ...

2024Aug6

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

ANmaReplace_Occurrence

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

2024Jul13

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

Just learnt that now

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

2024Mar5

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

2024Jan16

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

Protect txt file into word doc with password

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

2024Jan4

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

1 2 ...8 9