Excelã§è‡ªç„¶è¨€èªžå‡¦ç†: VBA with JScript
VBAã§JScriptã®Arrayオブジェクトã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚’使ã£ã¦ã¿ã‚‹ã‚µãƒ³ãƒ—ルã§ã™ã€‚ サンプルã§ã¯Sliceメソッドを使用ã—ã¦ã¿ã¦ã„ã¾ã™ã€‚ Sub JSArraySample() Set objJS = CreateObject("ScriptControl") With objJS .Language = "JScript" .AddCode "function JSSplit(s,d){return s.split(d);}" .AddCode "function JSArrayLength(a){return a.length;}" End With æ–‡å—列 = "a,b,c,d,e" Set b = objJS.CodeObject.JSSplit(æ–‡å—列, ",") Cells(1, 1).Value = b.slice(0, 1) Cells(1, 2).Va
Excel/VBAテクニック20é¸
表計算ソフトã®Excelã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®VBA（Visual Basic for Applications）を使ãˆã¾ã™ã€‚連載『Excel/VBAクリニックã€ä»Šæœˆã®è¨ºæ–ã€ã§ã¯ã€VBAを使ã†ä¸Šã§ç”Ÿã˜ã‚‹æ‚©ã¿ã‚„ç–‘å•ã‚’ã€ã‚¯ãƒªãƒ‹ãƒƒã‚¯å½¢å¼ã§è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ã€èªè€…ã‹ã‚‰ç‰¹ã«å¥½è©•ã ã£ãŸ20ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’紹介ã—ã¾ã™ã€‚ ãªãŠã€è¨˜äº‹å†…ã®ã‚µãƒ³ãƒ—ルコードãªã©ã¯ã€è¨˜äº‹å…¬é–‹å½“時ã®Excelã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚Excelã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦ã¯ã€å¿…ãšã—ã‚‚æ„図通りã«å‹•ä½œã—ãªã„å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ã‚らã‹ã˜ã‚ã”了承ãã ã•ã„。
MiniTemplator - A compact, optimized template engine for HTML files
MiniTemplator is a compact, optimized template engine for HTML files. Features Available for JavaScript, Java, PHP and Visual Basic (VB/VBA). Simple syntax for template variables and blocks. Blocks can be nested. A template can be parsed once and used many times. Open Source What is a Template Engine? A template engine is a software module which is used to generate HTML pages (or other text files)
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}