Learning Materials 74

Screenshots, videos or full articles as references or learning new technology

Sorted from new to old.

End ( xlDown )

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

2023Aug28

Enable Includes in ASP Classic

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

2023Aug7

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Enable Blocked Macros in O365 from OneDrive

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

2023Jul10

Detailed errors - Web.config

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

2023May25

Progress in two nested loops

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

2023Mar7

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

Too large procedures

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

2022Jan29

A is for Alpha

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

2021Dec6

ServerXMLHTTP stream

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

2021Aug3

Execute exe embedded in Excel

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

2021Apr16

HTML5 tags cheatsheet

A simple graphic illustrates the new HTML5 tags and differences against old ones

2021Apr16

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Bing Desktop wallpapers

Folder where

2021Mar5

2 VB.net pdf books

Free from apress website https://www.apress.com More books

2021Mar2

1 2 3 4 5