Search results 60

Sorted from new to old.

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

CutString_ANmaRules

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

Feb26

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

QuickEncrypt plus others ...

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

2024Aug15

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

ReturnLongestString_Of2

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

2024Jul2

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

2024Apr30

Triangular coded msg in file

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

2024Mar4

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

2022May3

1 2 3 4