Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

IsThere1_SPWB

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

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...