SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

web.config.zip

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

frmRename.zip

Excel user name

Get application user name or change it Originally from

MapPath_SafeComma

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

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...