Similar codes

Card image cap
SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

2018Jun30

Card image cap
WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9

Card image cap
SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

Card image cap
WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

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
IsThere1_Folder

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

2018Aug10

Card image cap
FixPath, IsThere, IsThere1 ...

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

2018Jun11

Card image cap
Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

Card image cap
SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

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
Card10-BS4

Card grid with BS4

2019Mar29

Card image cap
Tabs in BS4

Some smooth-look CSS3 Tabs in Bootstrap4, something other than default tabs :-)

2019Feb4

Card image cap
User profile card

A nice user profile card in Bootstrap3

2019Feb3

Card image cap
Create and Write Log File

The subprocedure can be called by any ASP applicaiton/page which needs to ...

2018Apr14