Search results 26

Sorted from new to old.

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

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

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

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

2018Sep29

Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

2018Sep26

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

2018Sep2

Thumbnail on fly

An aspx tool to generate thumbnail from an image, used to make page load faster ...

2018Aug10

1 2