Search results 70

Sorted from new to old.

ReadBinaryBuffer

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

2023Apr30

ScanFolder

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

2023Apr7

Excel recovered files

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

2023Mar31

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

1 2 3 4 5