Similar codes

Card image cap
Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

Card image cap
FileDate_Formatted

Returns a formatted version of file 'LastModified' date. Pass parameter ...

2018Apr25

Card image cap
FormatMyDate

Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...

2019Jan4

Card image cap
ANSQLWherein

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

2020Jan6

Card image cap
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Card image cap
NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2

Card image cap
FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11

Card image cap
CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

Card image cap
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my tools, very ...

2018Apr21

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Tue 7AM

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Random Codes

Card image cap
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

Sep3

Card image cap
Auth_User

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

2020Feb23

Card image cap
TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

2018Sep2

Card image cap
HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30