hochun836

// ==UserScript==
// @name         Style Microsoft documents
// @namespace    https://hochun836.com/
// @version      0.1
// @description  enhance experience of reading Microsoft documents
// @author       Ho.Chun
// @match        https://learn.microsoft.com/*
// @icon         data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==
// @grant        none
// ==/UserScript==

hochun836

Sub CombineSelectedCells()
    Dim selectedRange As Range
    Dim cell As Range
    Dim resultString As String
    
    ' 檢查是否有選擇的儲存格
    If Selection.Cells.Count > 1 Then
        ' 將選擇的儲存格合併成一個字串
        For Each cell In Selection
            resultString = resultString & """" & cell.Value & """, "

hochun836

# screentools.bat
start C:\software\gInk_v1.1.0\gInk.exe
start C:\software\ZoomIt.exe
start C:\software\Snipaste-1.16.2-x64\Snipaste.exe
start "" "C:\Program Files (x86)\DeskPins\deskpins.exe"
#start C:\software\copyq-7.0.0\copyq.exe

# HotKeyMapping.ahk
; for quick
!a::^Home

hochun836

# base
smtp (simple mail transfer protocol)

# telnet
telnet <host> // port: 23
telnet <host> <port>
telnet localhost 25 // enter interactive interface

# interactive (with hMailServer)
220 xxx ESMTP // xxx is server name

hochun836

# base

NOTE: download 'sqlite3.exe' for windows
sqlite-tools-win-x64-3440000.zip // a bundle of command-line tools (sqlite3.exe, sqldiff.exe, sqlite3_analyzer.exe)
=> ref: https://sqlite.org/download.html

# cmd
sqlite3 -help
sqlite3 -version
sqlite3 <db-name.db> // enter sqlite shell

hochun836

# base

# tools
android sdk command-line tools
android sdk build tools
android sdk platform tools
=> ref: https://developer.android.com/tools

NOTE: platform-tools
android sdk 'platform-tools' is a component for the android sdk

hochun836

# base

# RubyInstaller (install ruby for windows)
ridk --help // RubyInstaller Development Kit
ridk version // print RubyInstaller and MSYS2 versions
ridk install // install MSYS2 and MINGW dev tools (development toolchain)
ridk use // switch to a different ruby version

NOTE:
MSYS2 is required to install gems with C extensions

hochun836

# ftp client
ftp -h
ftp -s:filepath // specify a text file containing ftp commands
ftp // goto interactive, exit by quit

hochun836

# base

# common
echo $0 // show the using shell
chsh -s /bin/bash // bash: bourne again shell
chsh -s /bin/zsh // zsh: z shell
open . // open a folder with current path

# Homebrew
brew help // command not found

hochun836

# mongo shell
mongosh -h
mongosh --version
mongosh <db-address>
mongosh mongodb://<ip>
mongosh mongodb://<ip>:<port>
mongosh mongodb://<ip>:<port>/<db>
mongosh --host <ip>
mongosh --host <ip> --port <port>
mongosh --nodb // don't connect to mongod on startup - no 'db address' [arg] expected