Search results 89

Sorted from new to old.

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Auth_User

Find the user name (and domain) for logged in user for in an internal intranet ...

2020Feb23

Online Wordpress password hash generator

An online tool to generate password hash for wordpress, tried it just today ...

2020Feb13

ProtectString + UnProtectString

Protects or unprotects a string giving a password Using XorD and similar to ...

2020Jan10

XorD

Encrypt or decrypt a string using a key Similar to XorC, except you get to ...

2020Jan10

ProtectFile_XorD + UnProtectFile_XorD

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

2020Jan10

RandomGUID

Creates a random GUID number like ... 879AE395-E026-0A63-EFC1-152038C4400B ...

2019Dec18

Copy formulas

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

2019Oct3

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

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

2019Jun2

RC4 Encryption

A code inherited from an old application to protect or un-protect text in ...

2019May25

fnGenerateRandomString

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

2019May5

Anticipate WP

Under Construction plugin for wp

2019Apr29

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

1 2 3 ...5 6