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

ANString_Location

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

Tue 8AM

ANmarAmdeen

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

ANmarAmdeen

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

ANmarAmdeen

CopyFields_FromTo

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

Apr17

ANmarAmdeen

blueimp Gallery

Touch-enabled, responsive and customizable image and video gallery, carousel ...

Aug16

ANmarAmdeen

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

ANmarAmdeen

Auth_User

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

2020Feb23

ANmarAmdeen

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

ANmarAmdeen