Search results 482

Sorted from new to old.

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

DB_Connect

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

2020Mar20

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

2020Feb16

Animated form exit

Exit form with shrinking Shrinks the form, Pushes the form to the bottom of ...

2020Feb16

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

ASPjson

Read and write json data in and from Classic ASP From

2020Feb3

Shortcut website

Create a shortcut to website to open using Internet Explorer in 'InPrivate' ...

2020Jan22

IsThere2

Finds a file in giving its full path Similar to IsThere1 except this one uses ...

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

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

1 2 ...16 ...30 31