Random codes

Codes Required

IsThere1_SPWB

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

2020Apr1

ANmarAmdeen

IsThere1_Image

Searches for an image and return the file extension of found, or returns null ...

2019Dec7

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

FixPath, IsThere, IsThere1 ...

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

2018Jun11

ANmarAmdeen

IsThere1

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

2018Apr25

ANmarAmdeen

Similar codes

DelFiles

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

2020Apr1

ANmarAmdeen

Recurse and Rename

Recurses down a directory tree and renames files

2018Apr18

JeremyNevill

CreateFullTree

Creates full tree if not found

2018Jul9

ANmarAmdeen

CSS Flowchart

A simple CSS flow chart with links

2019Jan11

ANmarAmdeen

Treeview

CSS Tree, a treeview Originally from

2019Jan7

ANmarAmdeen

CSS Flowchart2

Another flowchart, this time with hover effect

2019Jan11

ANmarAmdeen

CSS Tree

One of those small CSSs I use in some of my projects, these are pure CSS, no ...

2018Dec17

ANmarAmdeen

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

ANmarAmdeen

FilesIn + FilesIn_Count

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

2018May22

ANmarAmdeen

Recently by developer

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

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

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Dec22

ANmarAmdeen

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Jul10

ANmarAmdeen

HTMLTagAttributeValue

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

2021May30

ANmarAmdeen