Random codes

Similar codes

Char(39) in SQL table

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

2019Aug31

ANmarAmdeen

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

ANmarAmdeen

Remove_Between2Quotes

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

2020Mar9

ANmarAmdeen

RemoveHTMLTags

Remove HTML tags from a string, note, this won't handle html encoding.

2018Jul15

DevinGarlit

CutString3

Cuts string from a larger one based on a specific separator.

2018May29

ANmarAmdeen

FrmAbout

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

2018Jun11

ANmarAmdeen

CutString3

Cuts string from a larger one based on a specific separator.

2018May29

ANmarAmdeen

CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...

2018May29

ANmarAmdeen

HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30

ANmarAmdeen

Recently by developer

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

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

Tue 7AM

ANmarAmdeen

MatchIf2Up

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

Mon 9AM

ANmarAmdeen

ANString_Location

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

Apr23

ANmarAmdeen

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Aug28

ANmarAmdeen

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

ANmarAmdeen

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

ANmarAmdeen

CapitalizeAllWords

Capitalize first letter in all words In a String

2018Jul15

DevinGarlit