Search results 38

Sorted from new to old.

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Aug15

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

Feb7

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1

Detailed errors - Web.config

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

2023May25

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

Too large procedures

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

2022Jan29

IsError_Range

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

2021Dec30

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

DB_Connect

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

2020Mar20

Auth_User

Find the user name (and domain) for logged in user for in an internal intranet ...

2020Feb23

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

FilesKill

Delete Multiple Files (with WildCards) To delete multiple files from a ...

2019Aug7

1 2 3