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

  2. Categories
  3. Learning Materials
Card image cap
Can't find Project or Library

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

Sep1
Card image cap
End ( xlDown )

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

Aug28
Card image cap
Enable Includes in ASP Classic

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

Aug7
Card image cap
Modal form open Workbook

Do not open workbook from userform after .show

Aug3
Card image cap
O365 Blocked Macros

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

Jul10
Card image cap
Detailed errors - Web.config

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

May25
Card image cap
Progress in two nested loops

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

Mar7
Card image cap
Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25
Card image cap
Too large procedures

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

2022Jan29
Card image cap
A is for Alpha

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

2021Dec6
Card image cap
ServerXMLHTTP stream

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

2021Aug3
Card image cap
Execute exe embedded in Excel

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

2021Apr16