Search results 60

Sorted from new to old.

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

Functions.dll

Old DLL housing list of functions to be used and called by any application, ...

2020Jul18

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

ProtectFile_XorD + UnProtectFile_XorD

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

2020Jan10

ANmaRedirect_Plus1

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

2019Oct25

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

FilesKill

Delete Multiple Files (with WildCards) To delete multiple files from a ...

2019Aug7

ConvertImage_IrfanView

Converts an image from any image into any image using IrfanView command line ...

2019Jun26

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5

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

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25

1 2 3 4