Search results 46

Sorted from new to old.

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

2019Jun2

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

2019Apr27

Convert HTML text into DB-safe string, by converting some characters as below. ...

2019Feb7

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

Solution to restore ASCII Arabic text files. Sometimes I noticed when system ...

2019Jan14

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9

Get output of DOS Command in string, by reading output into temp text file, ...

2018Jun22

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

2018Jun2

Prompt for a password, or username and password, returns information back to ...

2018May20