Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

ProtectFile_XorD + UnProtectFile_XorD

Protects and unprotects a file using password Creates another copy of the file ...

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

ANmaRedirect_Plus1

Function to log the redirects that happen into website It is merely used with ...

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

HTMLDecode + HTMLEncode

Decode and encode back a string using HTML Technically found online, but ...

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

Frm9.zip