Learning Materials 59 Screenshots, videos or full articles as references or learning new technology

Card image cap
Can't find Project or Library

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

Card image cap
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Card image cap
Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

Card image cap
Modal form open Workbook

Do not open workbook from userform after .show

Card image cap
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Card image cap
Detailed errors - Web.config

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

Card image cap
Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

Card image cap
Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

Card image cap
Too large procedures

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

Card image cap
A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

Card image cap
ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

Card image cap
Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...