Memoru

System Engineering and Programming and IT

2004-VBA Data Type

No Item Content ConvertFunc 1 Primitive 2 Boolean Dim bln As Boolean CBool(value) 3 Long Dim i As Long CLng(value) 4 Double Dim n As Double CDbl(value) 5 Currency Dim yen As Currency CCur(value) 6 Date Dim dtm As Date CDate(value) 7 String…

2004-VBE-Shortcuts

No Item Content 1 windows activation 2 Alt+F11 Change Active windows on VBE or Excel Sheet 3 ctrl+G Emmeditate Window 4 F7 Code Editor 5 Shift+F7 Object Ppoperty 6 F2 Object Browser 7 F4 Property Window 8 ctrl+R Project Browser 9 Alt+V+H W…

2003-ExcelVBA::function-parameter-definition

Excel VBA function parameter definition No Item Content 1 Optional "Every optional parameter in the procedure definition must specify a default value.The default value for an optional prameter must be a constant expression.Every parameter …

2003 [VBA] Tool of Module Export

overview To export modules on Excel VBA. Gist snippets.cacher.io Code

Runkit

Runkit Embed runkit.com Welcome to my website // GeoJSON! var getJSON = require("async-get-json"); await getJSON("https://storage.googleapis.com/maps-devrel/google.json");

Repl

repl (https://repl.it/@sakaimemoru/repl) Repl embed

2003-node-powershell

reference rannn505.gitbook.io get started console log PS G:\sandbox\nodepwsh> npm start > nodepwsh@1.0.0 start G:\sandbox\nodepwsh > node index Hello node and powershell Directory: G:\sandbox\nodepwsh Mode LastWriteTime Length Name ---- --…

2003-express-ejs-bootstrap-site-template :

2003-express-ejs-bootstrap-site-template : overview : create a express project with ejs template. set index.html from bootstrap template site. modify site pages with bootstrap template using ejs template engine. repository : github.com env…

1911-Sakura Macro::insert_memoLineWithTemplate.jse

sakura editorのmacroをさらす。insert memo

1911-Sakura Macro::open_vim.jse

sakura editorのmacroをさらす。open vim. gist gist.github.com

1911-Sakura Macro::open_mdeditor.jse

sakura Editor のmacroをさらす。open markdown editor. gist gist.github.com

1911-Sakura Macro::open_powershell.jse

sakura Editor のmacroをさらす。open powershell. gist gist.github.com

1911-Sakura Macro::open_explorer.jse

sakura Editor のmacroをさらす。open explorer. gist gist.github.com

Gist

1909-powershell-get-command

1909-powershell-get-command¶ overview¶ A Usage of get-command cmdlet jupyter notebook¶ https://nbviewer.jupyter.org/github/sakai-memoru/pwshnote/blob/master/1909-powershell-get-command.ipynb Usage¶ Get-Help¶ In [33]: Get-Help Get-Command -…

1909-powershell-datetime

1909-powershell-datetime¶ overview¶ datetime object on powershell jupyter notebook¶ https://nbviewer.jupyter.org/github/sakai-memoru/pwshnote/blob/master/1909-powershell-datetime.ipynb Usage¶basic¶ In [23]: Get-Date 02 September 2019 20:58…

1909-powershell-alias

1909-powershell-alias¶ overview¶ overview of alias on powershell jupyter notebook¶ https://nbviewer.jupyter.org/github/sakai-memoru/pwshnote/blob/master/1909-powershell-alias.ipynb contents¶ Basic¶ In [10]: pwd Path ---- G:\workspace\pwshn…

1908-powershell-hashtable

1908-powershell-hashtable¶ overview¶ hashtable object on powershell jupyter notebook¶ https://nbviewer.jupyter.org/github/sakai-memoru/pwshnote/blob/master/1908-powershell-hashtable.ipynb Usage¶ basic¶ In [1]: $d = @{ 'script' = 'powershel…

1908-powershell-array

1908-powershell-array¶ jupyter notebook¶ https://nbviewer.jupyter.org/github/sakai-memoru/pwshnote/blob/master/1908-powershell-array.ipynb 変数としてのarray の定義¶ Literalによる定義¶ In [1]: $ary = @('power','shell') In [2]: $ary power sh…

1908-powershell-alias-grep

1908-powershell-alias-grep overview powershellのAliasを、grepする notebook nbviewer.jupyter.org log $PSVersionTable get-alias | out-string -stream | select-string "new-item" get-alias | out-string -stream | select-string "Out" get-alias | …

1908-powershell-specialfolder-getfolderpath

1908-powershell-specialfolder-getfolderpath nbviewer nbviewer.jupyter.org code [Enum]::GetNames('System.Environment+SpecialFolder') $mydocfolder = [Environment]::GetFolderPath('MyDocuments') $mydocfolder $mydocfolder.GetType().FullName [En…

1908-powershell-split-path

1908-powershell-split-path overview powershellのsplit-pathのサンプルコード nbviewer nbviewer.jupyter.org conde $PSVersionTable $PROFILE $path = split-path $PROFILE -parent $path explorer $path split-path $PROFILE -leaf sakura $PROFILE

1905-open-control-panel-on-windows10

logs win key win+Pause key win+R , control, enter win, control , enter mouse my computer + 右click-property - 右上のcontrol panel start + 歯車マーク

1905-powershell-env-path-grep

[powershell] Env:pathをgrep console logs PS G:\Users\sakai> $Env:path C:\Ruby26-x64\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:…

GitHub Pagesでmarkdownを公開する3

**** GitHub Pagesでmarkdownを公開する3:Local環境を構築 *** overview Jekyll Themeが適用されたGitHub Pagesのrepositoryを、Local PC側でも閲覧可能とする。 *** relative posts sakai-memoru.hateblo.jp *** reference Github Pagesのデフォルトテー…

GitHub Pagesでmarkdownを公開する2

**** GitHub Pagesでmarkdownを公開する2:Repositoryをcloneし,markdownをpushする *** overview GitHub repositoryと連携して、GitHub Pagesにmarkdownファイルを公開する。 *** relative posts 1905-github-pages-with-jekyll-publishment sakai-memoru.…

GitHub Pagesでmarkdownを公開する1

**** GitHub Pagesでmarkdownを公開する1:GitHubにPagesに対応したReposを作る *** overview GitHub Pagesで、markdownファイルを、Jekyll Themeで公開する。 *** procedure ** note GitHubにrepositoryを作り、そのrepositoryを、GitHub Pagesとして公開…

1905-create-github-repos-of-notebook-on-first-operation

**** 1905-create-github-repos-of-notebook-on-first-operation *** overview When creating github repository, operate first on terminal. *** FIXME [ ] To publish github.io/blog *** logs echo "# zzzzz" >> README.md gibo dump python vim > .giti…

1905-sequence

**** 1905-sequence *** overview Sequence Types Sequences represent ordered sets of objects indeed by non-negative integers and include strings, lists, and tuples. *** logs import logging.config logging.config.fileConfig('./logging_debug.co…

1905-conda-operation

**** 1905-conda-operation [ ] FIXME Add articles for configuring requirements.txt *** overview logged operations of conda. *** reference Condaの使い方メモ https://qiita.com/showsuzu/items/e2fddf22f725f4d2ab8c *** logs ** execute Anaconda P…