Random codes

Codes Required

Files_FoundHours

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

Tue 7AM

ANmarAmdeen

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

ANmarAmdeen

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Mar4

ANmarAmdeen

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Jan15

ANmarAmdeen

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

ANmarAmdeen

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

ANmarAmdeen

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

ANmarAmdeen

DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1

ANmarAmdeen

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

ANmarAmdeen

IsThere1_Remote

Checks if a file is found from a URL, finds a file in a remote server

2018Aug10

ANmarAmdeen

IsThere1_Folder

Checks if a folder is found or not, can pass either mapped path or unmapped ...

2018Aug10

ANmarAmdeen

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

ANmarAmdeen

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

ANmarAmdeen

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

ANmarAmdeen

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

ANmarAmdeen

DownloadFile

Download a file from URL from inside Excel into certain path, returns blank if ...

2018May22

ANmarAmdeen

FileSize_Formatted

Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...

2018Apr25

ANmarAmdeen

FileDate_Formatted

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

2018Apr25

ANmarAmdeen

DB_SettingRead + DB_SettingSave + ...

Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...

2018Apr14

ANmarAmdeen

FileisImage

Checks if file is an image using its filename extension

2018Apr14

ANmarAmdeen

Similar codes

ViewSource

Display content of ASP file (any file for that matters)

2018Jul11

ANmarAmdeen

FrmLarge v3

Shows an image after clicking on its thumbnail, like in web applications Can ...

2018May20

ANmarAmdeen

PrettyPath

Formats a path for use in user displays, trim it beautifly. PrettyPath is ...

2018Sep23

ANmarAmdeen

Char(39) in SQL table

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

2019Aug31

ANmarAmdeen

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

ANmarAmdeen

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

ANmarAmdeen

RemoveHTMLTags

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

2018Jul15

DevinGarlit

IsThere1

Finds out if a file exists, can pass either mapped file path, or unmapped

2018Apr25

ANmarAmdeen

GetRelativePath

Get relative path of one to another Pass two path strings to this function and ...

2018Jul19

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

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

ANmarAmdeen

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

ANmarAmdeen

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

ANmarAmdeen

Loading3 gif

Showing animated gif when ancher is clicked, uses an overlay to prevent user ...

2018Sep23

ANmarAmdeen