Search results 61

Sorted from new to old.

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

2025Apr6

TrimLines

Remove all line breaks from text from a text. Not like

2025Jan31

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

USB format in Android

What is the best format to use a USB storage for using in Android phones and ...

2023Sep28

ListPivotsInfo

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

2023Aug13

Range22DimArray

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

2023May11

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

LastRow_Remove

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

2022Aug16

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

Too large procedures

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

2022Jan29

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

1 2 3 4