Codes Required

Similar codes

Card image cap
IsThere1

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

2018Apr25

Card image cap
KillFile

Deletes a file, using mapped or unmapped file path

2018Apr21

Card image cap
IsThere2

Finds a file in giving its full path Similar to IsThere1 except this one uses ...

2020Jan10

Card image cap
FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

Card image cap
CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

Mar12

Card image cap
FixPath, IsThere, IsThere1 ...

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

2018Jun11

Card image cap
FilesIn + FilesIn_Count

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

2018May22

Card image cap
MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

May19

Card image cap
IsThere1_Remote

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

2018Aug10

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

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

Tue 7AM

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

Card image cap
ANString_Location

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

Apr23

Random Codes

Card image cap
Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

Card image cap
CSS Flowchart2

Another flowchart, this time with hover effect

2019Jan11

Card image cap
CapitalizeAllWords

Capitalize first letter in all words In a String

2018Jul15

Card image cap
FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6