Search results 133

Sorted from new to old.

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

ANmAraDate

Format full date in Arabic language using several known Arabic month syntax. ...

2025Jun12

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

2025May26

ANmaUploadFTP_FilesFrom2Columns

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

2025May4

ANmaUploadFTP_Script + ANmaUploadFTP_1File

Uploads 1 file to FTP. It will create temp script to login to FTP and uploads ...

2025Apr27

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

2025Apr10

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

2025Mar20

VBA/Excel Registry hacks

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

2025Mar12

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

2025Feb1

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

2025Jan12

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

2025Jan8

ANmaRemoveDuplicates2

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

2024Dec4

CutString96_NumberBefore and After

Cuts the number found before our search word by going back certain number of ...

2024Nov24

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

ConditionalFormatting_ColorARow

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

2024Nov10

HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

2024Oct6

1 2 ...8 9