Random codes

Codes Required

GetPapa

Gets folder name of a page using FSO

2018Jun24

ANmarAmdeen

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

ANmarAmdeen

GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

Gets that parent folder name giving a full path, or gets the child folder, Can ...

2018May22

ANmarAmdeen

Similar codes

DelFiles

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

2020Apr1

ANmarAmdeen

Remove_Between2Quotes

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

2020Mar9

ANmarAmdeen

strUnQuote

This will tests to see if strQuotedString is wrapped in quotation marks, and, ...

2018Jul3

ANmarAmdeen

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

ANmarAmdeen

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

ANmarAmdeen

FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

2018May22

ANmarAmdeen

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

ANmarAmdeen

Char(39) in SQL table

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

2019Aug31

ANmarAmdeen

KillFile

Deletes a file, using mapped or unmapped file path

2018Apr21

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

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

Dec16

ANmarAmdeen

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

Oct11

ANmarAmdeen

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

ANmarAmdeen

Multi-level menu

CSS only. Bootstrap multi-level menu Originally from

2019Jun19

ANmarAmdeen