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

FileDate_Formatted

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

2018Apr25

ANmarAmdeen

FormatMyDate

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

2019Jan4

ANmarAmdeen

ANSQLWherein

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

2020Jan6

ANmarAmdeen

Convert_Dash_to_Zero

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

2023Mar14

ANmarAmdeen

NumberNumberNumber

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

Mar2

ANmarAmdeen

FrmAbout

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

2018Jun11

ANmarAmdeen

CutString

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

2018May29

ANmarAmdeen

ASCII_Read + ASCII_Save

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

2018Apr21

ANmarAmdeen

Recently by developer

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

Thu 3PM

ANmarAmdeen

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

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

Apr30

ANmarAmdeen

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

Dec29

ANmarAmdeen

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

Jul24

ANmarAmdeen

Restore Arabic text files

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

2019Jan14

ANmarAmdeen

CapitalizeAllWords

Capitalize first letter in all words In a String

2018Jul15

DevinGarlit