Search results 90

Sorted from new to old.

DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1

Evaluate

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

2020Feb16

Decode and NVL

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

2020Feb7

Excel-VBA Limits

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

2020Feb5

ProtectFile_XorD + UnProtectFile_XorD

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

2020Jan10

GeneratePostID

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

2019Dec19

ANmaRedirect_Plus1

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

2019Oct25

ShrinkText

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

2019Oct20

Copy formulas

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

2019Oct3

CountArrayCol

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

2019Aug9

HTMLDecode + HTMLEncode

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

2019Aug9

ANmaDB functions

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

2019Apr14

Frm9 - Select workbook (or workbook/worksheet)

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

2019Apr3

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9

1 2 ...4 5 6