Skip to content

Monthly Archives: June 2020

Buffalo NAS external drives & Windows 10 will not connect


Control Panel – Programs and Features – Turn Windows features on and off and enabled:
SMB 1.0/CIFS File Sharing Support
Restarted and everything worked.

Add-Remove Programs client method…

Pad single-digit numbers with a zero


VBA has a Format() function that you can use to pad numbers.

animal = “sinani-” & Format$(i, “00”)
This will pad single-digit numbers with a 0. Your two- and three-digit numbers will continue to work as expected.


Strings and Manipulations(VBA)


Text Functions, Workbook
Before continuing please be aware of the following information available in Excel HELP

Worksheet Description VBA
CHAR Returns the character specified by the code number CHR
CLEAN Removes all nonprintable characters from text
Characters 0-31, 129, …