[B! office] fukudamasa09ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

fukudamasa09 id:fukudamasa09

officeã«é–¢ã™ã‚‹fukudamasa09ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (29)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

http://www.msactry.com/
fukudamasa09 2014/08/08
database

Access

tips

microsoft

office

Windows

DB

æœªã‚«ãƒ†ã‚´ãƒª

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

PC
ãƒªãƒ³ã‚¯
Office TANAKA - Excel VBA Tips[æ£è¦è¡¨ç¾ã«ã‚ˆã‚‹ãƒžãƒƒãƒãƒ³ã‚°]
VBAã‹ã‚‰æ£è¦è¡¨ç¾ã‚’ä½¿ã†ã«ã¯ã€VBScriptãŒä¾¿åˆ©ã§ã™ã€‚ãŸã ã—ã€æ£è¦è¡¨ç¾ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹VBScriptã¯Ver5.0ã‹ã‚‰ã§ã™ã‹ã‚‰ã€IE5.0ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ãƒ‘ã‚½ã‚³ãƒ³ã§ãªã„ã¨ä½¿ãˆã¾ã›ã‚“ã€‚ VBScriptã®ä¸ã§æ£è¦è¡¨ç¾ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æä¾›ã—ã¦ã„ã‚‹ã®ã¯RegExpã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§ã™ã€‚å‚ç…§è¨å®šã«ã‚ˆã‚‹Early Bindingã‹ã€CreateObjecté–¢æ•°ã‚’ä½¿ã£ãŸLate Bindingã§å‚ç…§ã—ã¾ã™ã€‚ã“ã“ã§ã¯Late Bindingã«ã‚ˆã‚‹ã‚µãƒ³ãƒ—ãƒ«ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã¾ãšã¯ã€æ£è¦è¡¨ç¾ã§ä½¿ç”¨ã™ã‚‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚„ãƒ¡ã‚½ãƒƒãƒ‰ã‚’æ•´ç†ã—ã¾ã—ã‚‡ã†ã€‚ RegExpã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã¨ãƒ¡ã‚½ãƒƒãƒ‰
fukudamasa09 2014/05/21
VBA

vbs

æ£è¦è¡¨ç¾

Excel

regex

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Office

VBScript

RegExp

tips
ãƒªãƒ³ã‚¯
Office TANAKA - Excel VBA Tips[é‡è¤‡ã—ãªã„ãƒªã‚¹ãƒˆã‚’ä½œã‚‹(1)]
ã€Œã‚ãƒ¼ã€ã¨ã€Œå€¤ã€ãŒã‚»ãƒƒãƒˆã«ãªã£ã¦ã„ã¦ã€ã€Œç¥žå¥ˆå·çœŒã€ã¨ã„ã†ã‚ãƒ¼ã§ã€Œæ¨ªæµœå¸‚ã€ã¨ã„ã†å€¤ã‚’æ¤œç´¢ã§ãã‚‹ã‚ˆã†ãªä»•çµ„ã¿ã§ã™ã€‚Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§ã¯ã€ã“ã†ã—ãŸé€£æƒ³é…åˆ—ã«ãƒ‡ãƒ¼ã‚¿(ã‚ãƒ¼ã¨å€¤ã®ã‚»ãƒƒãƒˆ)ã‚’è¿½åŠ ã—ãŸã‚Šã€æ¤œç´¢ã—ãŸã‚Šã€ä»»æ„ã®ã‚ãƒ¼ãŒã™ã§ã«å˜åœ¨ã—ã¦ã„ã‚‹ã‹ã©ã†ã‹ã‚’èª¿ã¹ã“ã¨ãªã©ãŒã§ãã¾ã™ã€‚ãªãŠã€é€£æƒ³é…åˆ—ã§ã¯åŒã˜ã‚ãƒ¼ã‚’ç™»éŒ²ã§ãã¾ã›ã‚“ã€‚ Dictionaryã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½¿ã£ã¦é‡è¤‡ã—ãªã„ãƒªã‚¹ãƒˆã‚’ä½œæˆã™ã‚‹ã«ã¯ã€æ¬¡ã®ã‚ˆã†ã«è€ƒãˆã¾ã™ã€‚ ã‚»ãƒ«A2ã‹ã‚‰ã‚»ãƒ«A8ã¾ã§é †ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ã¾ã™ å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ãŒé€£æƒ³é…åˆ—ã«ç™»éŒ²ã•ã‚Œã¦ã„ãªã‹ã£ãŸã‚‰ç™»éŒ²ã—ã¾ã™ å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ãŒé€£æƒ³é…åˆ—ã«ç™»éŒ²ã•ã‚Œã¦ã„ãŸã‚‰ä½•ã‚‚ã—ã¾ã›ã‚“ æµã‚Œã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ã•ã¦ç™»éŒ²ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã§ã™ãŒã€é€£æƒ³é…åˆ—ã§ã¯ã€Œã‚ãƒ¼ã€ã¨ã€Œå€¤ã€ã®äºŒã¤ãŒå¿…è¦ã§ã™ã€‚ä»Šå›žã®ã‚±ãƒ¼ã‚¹ã§ã¯ã€Œåå‰ã€ãƒ‡ãƒ¼ã‚¿ã—ã‹ã‚ã‚Šã¾ã›ã‚“ã€‚ã€Œåå‰ã€ã‚’ã€Œã‚ãƒ¼ã€ã«ã™ã‚‹ã¨ã—ã¦ã€ã€Œå€¤ã€ã«ã¯ä½•ã‚’ç™»éŒ²ã—ãŸã‚‰ã„ã„ã®ã§ã—ã‚‡ã†ã€‚
fukudamasa09 2014/05/01
AS

Microsoft

()

access

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Excel

VBA

Office

é€£æƒ³é…åˆ—

é‡è¤‡ãƒã‚§ãƒƒã‚¯
ãƒªãƒ³ã‚¯
Excel(ã‚¨ã‚¯ã‚»ãƒ«)å…¥é–€/åŸºæœ¬/ä¸Šç´š/å®Ÿç”¨è¬›åº§ã®ç·ç›®æ¬¡
Excel(ã‚¨ã‚¯ã‚»ãƒ«)åŸºæœ¬è¬›åº§ç›®æ¬¡ [ExcelåŸºæœ¬è¬›åº§ã¸GO!] å„é …ç›®æ¯Žã«è©³ç´°ã«èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ åŸºæœ¬çš„ãªä½¿ã„æ–¹ã‚’å¿˜ã‚ŒãŸã¨ãã«ä¾¿åˆ©? åŸºæœ¬æ“ä½œ(ä¸€èˆ¬æ“ä½œ) Excelã®èµ·å‹•ã¨çµ‚äº† Excelã‚’èµ·å‹•ã™ã‚‹ Excelã‚’çµ‚äº†ã™ã‚‹ ç”»é¢æ§‹æˆ ç”»é¢ã®åç§°ã¨ç°¡å˜ãªèª¬æ˜Ž ã‚·ãƒ¼ãƒˆã®æ“ä½œ æ¨™æº–ã‚·ãƒ¼ãƒˆæ•°ã®å¤‰æ›´ã¨ã‚·ãƒ¼ãƒˆåã®å¤‰æ›´ ã‚·ãƒ¼ãƒˆã®æœ€å¤§è¡Œåˆ—æ•° æ–°è¦ã‚·ãƒ¼ãƒˆæ•°ã®å¤‰æ›´ ã‚·ãƒ¼ãƒˆåã®å¤‰æ›´ ã‚·ãƒ¼ãƒˆã®è¿½åŠ ã¨å‰Šé™¤ãŠã‚ˆã³éžè¡¨ç¤º ã‚·ãƒ¼ãƒˆã®è¿½åŠ ã‚·ãƒ¼ãƒˆã®å‰Šé™¤ ã‚·ãƒ¼ãƒˆã‚’éžè¡¨ç¤ºã«ã™ã‚‹ ã‚·ãƒ¼ãƒˆã®å†è¡¨ç¤ºã‚’ç¦æ¢ã™ã‚‹ ã‚·ãƒ¼ãƒˆã®ç§»å‹•ã¨ã‚³ãƒ”ãƒ¼ ã‚·ãƒ¼ãƒˆã®ç§»å‹• ã‚·ãƒ¼ãƒˆã®ã‚³ãƒ”ãƒ¼ è¤‡æ•°ã‚·ãƒ¼ãƒˆã®æ“ä½œ è¤‡æ•°ã®ã‚·ãƒ¼ãƒˆã‚’è¡¨ç¤ºã™ã‚‹ è¤‡æ•°ã®ã‚·ãƒ¼ãƒˆã«åŒæ™‚ã«å…¥åŠ›ã‚„æ›¸å¼ã‚’è¨å®šã™ã‚‹ å¤šãã®ã‚·ãƒ¼ãƒˆã‹ã‚‰ç´ æ—©ãç›®çš„ã®ã‚·ãƒ¼ãƒˆã‚’é¸æŠžã™ã‚‹ ã‚·ãƒ¼ãƒˆã®ä¿è· ã‚·ãƒ¼ãƒˆã®æ“ä½œ ã‚»ãƒ«ã®æ“ä½œ ã‚»ãƒ«ã®æ“ä½œæ–¹æ³• ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚»ãƒ«ã®ç§»å‹• ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚»ãƒ«ã®ç§»å‹•ã®åŸºæœ¬ ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚»ãƒ«ã®ç§»å‹•ã®å¿œç”¨ åŠ¹çŽ‡çš„ãª
fukudamasa09 2014/04/30
excel

tips

office

ä»•äº‹

VBA

ã‚¨ã‚¯ã‚»ãƒ«

windows

ã¾ã¨ã‚

å…¥é–€

microsoft
ãƒªãƒ³ã‚¯
Office TANAKA - ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆé–¢æ•°[OFFSET é–¢æ•°]
OFFSETé–¢æ•°ã«é–¢ã—ã¦ã€è©³ã—ã„èª¬æ˜Žã‚„å…·ä½“çš„ãªä½¿ã„æ–¹ãªã©ã‚’å‹•ç”»ã§è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãœã²ã€ã”è¦§ãã ã•ã„ã€‚Youtubeã§ã¯ã€ã»ã‹ã«ã‚‚ãŸãã•ã‚“ã®å‹•ç”»ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ãƒãƒ£ãƒ³ãƒãƒ«ç™»éŒ²ã‚’ãŠå¿˜ã‚Œãªãï¼ Office TANAKAãƒãƒ£ãƒ³ãƒãƒ« æ›¸å¼ ï¼šOFFSET(åŸºæº–,è¡Œæ•°,åˆ—æ•°,é«˜ã•,å¹…) æ©Ÿèƒ½ ï¼šåŸºæº–ã‚»ãƒ«ã‚’æŒ‡å®šã—ãŸæ•°ã ã‘ã‚·ãƒ•ãƒˆã—ãŸã‚»ãƒ«ç¯„å›²ã‚’è¿”ã—ã¾ã™ è§£èª¬ ï¼šã‚»ãƒ«ç¯„å›²ã‚’å¯å¤‰ã«ã™ã‚‹ã¨ãã«ä½¿ã„ã¾ã™ OFFSETé–¢æ•°ã®ä»•çµ„ã¿ OFFSETé–¢æ•°ã¯ç†è§£ã—ã¥ã‚‰ã„é–¢æ•°ã®ã²ã¨ã¤ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•çµ„ã¿ã‚’ç†è§£ã§ãã‚Œã°ã€ã“ã‚Œã»ã©å½¹ã«ç«‹ã¤é–¢æ•°ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã¾ãšã€OFFSETé–¢æ•°ã¯ä½•ã‚’ã©ã†ã™ã‚‹é–¢æ•°ãªã®ã‹ã‚’ç†è§£ã—ã¾ã—ã‚‡ã†ã€‚ OFFSETé–¢æ•°ã®æ§‹æ–‡ã¯æ¬¡ã®é€šã‚Šã§ã™ã€‚ OFFSET(åŸºæº–,è¡Œæ•°,åˆ—æ•°,é«˜ã•,å¹…) OFFSETé–¢æ•°ã«æŒ‡å®šã™ã‚‹å¼•æ•°ã¯ã€æ¬¡ã®3ç¨®é¡žã«åˆ†é¡žã§ãã¾ã™ã€‚ 1.åŸºæº–ã¨ãªã‚‹ã‚»ãƒ«ã‚’æŒ‡å®šã™ã‚‹å¼•æ•°â†’[åŸºæº–] 2.åŸºæº–ã‚»ãƒ«ã‚’å‹•
fukudamasa09 2014/04/30
excel

OFFSET

ä»•çµ„ã¿

é–¢æ•°

office

pc

a-excel

ã‚¨ã‚¯ã‚»ãƒ«

tips
ãƒªãƒ³ã‚¯
1GBãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãƒ»ãƒ—ãƒãƒã‚¤ãƒ€ãƒ¼ Amusement BiG-NET | www.big.or.jp/~seto/vbaref/vbaref13.htm
ã“ã¡ã‚‰ã¯ç‹¬è‡ªãƒ‰ãƒ¡ã‚¤ãƒ³ã‹ã‚‰ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã€ãƒ•ãƒ¬ãƒƒãƒ„æŽ¥ç¶šå°‚ç”¨ä¼šå“¡ã¾ã§ãƒˆãƒ¼ã‚¿ãƒ«ã‚µãƒãƒ¼ãƒˆã®ãƒ—ãƒãƒã‚¤ãƒ€ãƒ¼ã€BiG-NETã§ã™ã€‚ ã„ã¤ã‚‚å¼Šç¤¾ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã—ã¦é ‚ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ http://www.big.or.jp/~seto/vbaref/vbaref13.htm 404 Not Found (ãƒ•ã‚¡ã‚¤ãƒ«ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“) ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ãŒã€ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹è¦æ±‚ã•ã‚Œã¾ã—ãŸä¸Šè¨˜ãƒšãƒ¼ã‚¸ã¯ã€ç¾åœ¨ã‚¢ã‚¯ã‚»ã‚¹ãŒå‡ºæ¥ã¾ã›ã‚“ã€‚ å¼Šç¤¾ã§ã¯ã€ãªãœã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ã®ã‹ã¨è¨€ã†ç¬¬ä¸‰è€…ã‹ã‚‰ã®ãŠå•ã„åˆã‚ã›ã«ã¯ãŠç”ãˆã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã›ã‚“ã€‚ ã‚‚ã—ã“ã®ãƒšãƒ¼ã‚¸ã®é–¢ä¿‚è€…ã‚’ã”å˜çŸ¥ã§ã—ãŸã‚‰ã€é€£çµ¡ã‚’å–ã£ã¦ã¿ã‚‹ã“ã¨ã‚’ãŠè–¦ã‚è‡´ã—ã¾ã™ã€‚ ä½•å’ã”å®¹èµ¦ä¸‹ã•ã„ã€‚
fukudamasa09 2014/04/25
ãƒ•ã‚©ãƒ«ãƒ€

application

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

VBA API

Office

Excel

excel-vba

*VB

VBA

displayfullscreen
ãƒªãƒ³ã‚¯
BOAT-æ¸‹è°·ã®ãƒ•ãƒªãƒ¼ã‚·ã‚§ã‚¢ã‚ªãƒ•ã‚£ã‚¹ | æ ªå¼ä¼šç¤¾VOYAGE GROUP
BOATã¯ã€Œã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆé ˜åŸŸã§èµ·æ¥ã—ãŸã„ã€ã¨ã„ã†ç†±ã„æƒ³ã„ã‚„ãƒ“ã‚¸ãƒ§ãƒ³ã‚’æŒã£ãŸå¦ç”Ÿãƒ»è‹¥æ‰‹èµ·æ¥å®¶ã‚’æ”¯æ´ã™ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã™ã€‚ã‚ªãƒ•ã‚£ã‚¹ã‚¹ãƒšãƒ¼ã‚¹ã®ã‚·ã‚§ã‚¢ã¯ã‚‚ã¡ã‚ã‚“ã€VOYAGE GROUPã®æ–½è¨ã®æä¾›ã‚„ã‚¯ãƒ«ãƒ¼ã¨ã®ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚ˆã‚Šã€è‹¥æ‰‹ä¼æ¥å®¶ã‚’æ”¯æ´ã—ã¦ã„ã¾ã™ã€‚BOATã¸ã®å…¥å±…è€…ã¯ã€VOYAGE GROUPã‚ªãƒ•ã‚£ã‚¹å†…ã®BOATå…¥å±…è€…ç”¨åŸ·å‹™ã‚¹ãƒšãƒ¼ã‚¹ã ã‘ã§ã¯ãªãã€æ¥å®¢ç”¨ä¼šè°å®¤ã‚„ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆç’°å¢ƒãªã©ã‚’ã€24æ™‚é–“ç„¡æ–™ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚
fukudamasa09 2014/04/07
business

ã‚·ã‚§ã‚¢

VOYAGE

office

èµ·æ¥

ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—

ã‚ªãƒ•ã‚£ã‚¹

share

startup

ã‚·ã‚§ã‚¢ã‚ªãƒ•ã‚£ã‚¹
ãƒªãƒ³ã‚¯
Wordï¼šãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ã‚’ä½¿ã£ãŸæ¤œç´¢ã¨ç½®æ›ã‚’æ¥µã‚ã‚‹ - æ•™ãˆã¦ï¼HELPDESK
ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ã‚’ä½¿ã£ãŸæ¤œç´¢ã¨ç½®æ›ã‚’æ¥µã‚ã‚‹ 1 â‰« 2 â‰« 3 â‰« 4 æ¤œç´¢ï¼ç½®æ›ã‚’è¡Œã†éš›ã€ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ã‚’ä½¿ã†ã¨è©³ç´°ãªæ¡ä»¶ã‚’æŒ‡å®šã—ã¦æ¤œç´¢ã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ã¨ã¯ç‰¹å®šã®æ–‡å—ã§ã¯ãªãã€Œä»»æ„ã®æ–‡å—ã€ã‚’è¡¨ã—ã€ã“ã‚Œã‚’ä½¿ã†ã“ã¨ã«ã‚ˆã‚Šæ§˜ã€…ãªæ¡ä»¶ã‚’è¨å®šã§ãã¾ã™ã€‚
fukudamasa09 2013/12/06
Word

office
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
fukudamasa09 2013/10/30
ã¾ã¨ã‚

ã¾ã¨ã‚

ç¤¾å“¡é£Ÿå ‚

ç”»åƒ

ä¼æ¥

ä»•äº‹

office

naver

æ–™ç†

ã‚·_ç¤¾å“¡é£Ÿå ‚
ãƒªãƒ³ã‚¯
æš®ã‚‰ã—ã®æƒ…å ±ã‚µã‚¤ãƒˆnanapiã¯ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸ | nanapi [ãƒŠãƒŠãƒ”]
2020å¹´8æœˆ31æ—¥(æœˆ)ã‚’ã‚‚ã¡ã¾ã—ã¦ã€nanapiã«é–¢ã‚ã‚‹ã™ã¹ã¦ã®ã‚µãƒ¼ãƒ“ã‚¹ã¯çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ nanapiã¯ã€2009å¹´ã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‚ˆã‚Šã€Œã¿ã‚“ãªã§ä½œã‚‹æš®ã‚‰ã—ã®ãƒ¬ã‚·ãƒ”ã€ã¨ã„ã†è€ƒãˆã®ã‚‚ã¨ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®çš†ã•ã¾ã«ç”Ÿæ´»ã«é–¢ã™ã‚‹æ§˜ã€…ãªã€Œãƒã‚¦ãƒ„ãƒ¼ã€ã‚’æŠ•ç¨¿ã—ã¦ã„ãŸã ãæŠ•ç¨¿åž‹ãƒã‚¦ãƒ„ãƒ¼ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦é‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€‚ ç´„11å¹´é–“ã«ã‚ãŸã£ã¦çš†ã•ã¾ã‹ã‚‰ã”æ”¯æ´ã‚’ã„ãŸã ãã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶™ç¶šã§ããŸã“ã¨ã€nanapiç·¨é›†éƒ¨ä¸€åŒã€å¿ƒã‚ˆã‚Šå¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ æŽ²è¼‰ã•ã‚Œã¦ã„ãŸã‚³ãƒ³ãƒ†ãƒ³ãƒ„ãªã©ã®nanapiã«ã¤ã„ã¦ã®ãŠå•ã„åˆã‚ã›ã¯ã€nanapi@supership.jp ã¾ã§ãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ é•·ãã«æ¸¡ã‚Šnanapiã‚’å¿œæ´ã—ã¦ãã ã•ã‚Šã€æœ¬å½“ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
fukudamasa09 2013/05/20
Excel

google

google docs

é–¢æ•°

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

spreadsheet

Office

googleDrive

ã‚¢ãƒ—ãƒªæƒ…å ±

#web
ãƒªãƒ³ã‚¯
æœ¬å½“ã¯æ€–ã„Excelï¼ˆã‚¨ã‚¯ã‚»ãƒ«ï¼‰ã®è©±
æœ¬å½“ã¯æ€–ã„Excelï¼ˆã‚¨ã‚¯ã‚»ãƒ«ï¼‰ã®è©±ã¯ã€ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã®ãŸã‚ã®æ–°æ„Ÿè¦šExcelè¬›åº§ã§ã™ã€‚æ”¾ã£ã¦ãŠãã¨æ¥å‹™åŠ¹çŽ‡ãŒå¤§å¤‰ãªã“ã¨ã«ãªã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã‚ˆãƒ»ãƒ»ãƒ» ãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯ã®æ™‚ä»£ã€ã©ã†ã‚„ã£ã¦æ¥å‹™åŠ¹çŽ‡åŒ–ã‚’å›³ã‚‹ã‹ãƒ»ãƒ»ãƒ»ã€‚ çµŒå–¶è€…ãƒ»ãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼ã¨ã—ã¦ã®æ‰‹è…•ãŒè©¦ã•ã‚Œã‚‹æ™‚ãŒã‚„ã£ã¦ãã¾ã—ãŸã€‚ ã•ã¦ã€å¤§å¤‰ã”ç„¡æ²™æ±°ã—ã¦ãŠã‚Šã¾ã™ã€‚ãƒžã‚¹å¤«ã§ã™ã€‚ ãŠä¼šã„ã—ã¦ã„ãªã„é–“ã«ã€ä¸–ã®ä¸ã§ã¯ãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯ãŒä¸€æ°—ã«æµ¸é€ã—ã¾ã—ãŸãã€‚ ãã“ã§å¤§æ´»èºã™ã‚‹ã®ãŒã€Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã€‚ æ—¢ã«ã”å˜çŸ¥ã ã¨ã¯æ€ã„ã¾ã™ãŒã€Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¨ã¯ã€Googleä¸Šã§ä½¿ãˆã‚‹è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã®ã“ã¨ã§ã€ãã®æ©Ÿèƒ½ã¯Excelã¨ã»ã¨ã‚“ã©åŒã˜ã€‚ ã§ã¯ã€ãªãœãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯ã§ã¯Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆãŒé‡å®ã•ã‚Œã‚‹ã®ã‹ï¼Ÿ ãã‚Œã¯ã€ä¾¿åˆ©ã™ãŽã‚‹ã€Œå…±æœ‰æ©Ÿèƒ½ã€ãŒã‚ã‚‹ã‹ã‚‰ã€‚ ä»Šå›žã¯ã€ã“ã®Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®å…±æœ‰æ©Ÿèƒ½ã«ã¤ã„ã¦ã”ç´¹ä»‹ã„ãŸã—ã¾ã™ã€‚ ä½¿ã„ã“ãªã™ã“ã¨
fukudamasa09 2013/03/04
Excel

tips

ã‚¨ã‚¯ã‚»ãƒ«

Office

ã‚ã¨ã§èªã‚€

work

å‚è€ƒ

å‹‰å¼·

é€£è¼‰

ä»•äº‹
ãƒªãƒ³ã‚¯
Windowsã§Officeãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’Webãƒ–ãƒ©ã‚¦ã‚¶ãƒ¼ã§é–‹ã‹ãªã„ã‚ˆã†ã«ã™ã‚‹
è§£èª¬ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆä¸Šã®Webãƒšãƒ¼ã‚¸ã®ä¸ã«ã¯ã€Wordã‚„Excelãªã©ã®Officeã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ãŒç›´æŽ¥ç½®ã‹ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚‹ã€‚ã“ã®ã‚ˆã†ãªãƒªãƒ³ã‚¯ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨ã€ä»¥ä¸‹ã®ãƒ€ã‚¤ã‚¢ãƒã‚°ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ Webãƒšãƒ¼ã‚¸ã«è¨å®šã•ã‚ŒãŸWordãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¸ã®ãƒªãƒ³ã‚¯ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ãŸä¾‹ Webãƒšãƒ¼ã‚¸ä¸Šã«è¨å®šã•ã‚ŒãŸOfficeãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ã¸ã®ãƒªãƒ³ã‚¯ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨ã€ã“ã®ã‚ˆã†ãªç¢ºèªãƒ€ã‚¤ã‚¢ãƒã‚°ãŒè¡¨ç¤ºã•ã‚Œã‚‹ï¼ˆã“ã‚Œã¯Windows XP SP2ã®ä¾‹ï¼‰ã€‚ ï¼ˆ1ï¼‰ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ä¸€æ™‚ãƒ•ã‚©ãƒ«ãƒ€ã«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‹ã‚‰é–‹ãã€‚ ï¼ˆ2ï¼‰ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ä»»æ„ã®ãƒ•ã‚©ãƒ«ãƒ€ã«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ã“ã“ã§ï¼»ä¿å˜ï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚Œã°ã€æ¨™æº–ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®ä¿å˜ãƒ€ã‚¤ã‚¢ãƒã‚°ãŒè¡¨ç¤ºã•ã‚Œã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä»»æ„ã®ãƒ•ã‚©ãƒ«ãƒ€ã«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ä¿å˜ã§ãã‚‹ã€‚ä¸€æ™‚çš„ãªå‚ç…§ã§ã¯ãªãã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ä¿å˜ã—ã¦ä½¿ã„å›žã—ãŸã„ã€å¾Œã§ã˜ã£ãã‚Šèªã¿ãŸã„ã¨ã„ã£ãŸå ´åˆã«ã¯
fukudamasa09 2012/09/26
ie

IT

Windows

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

office

word

ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿

u

Web

sft
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã«ã‚ˆã‚‹ç›¸é–¢ä¿‚æ•°ã®æ±‚ã‚æ–¹
ï¼‘ï¼Žã‚¨ã‚¯ã‚»ãƒ«ã«ã‚ˆã£ã¦ç›¸é–¢ä¿‚æ•°ã‚’è¨ˆç®—ã™ã‚‹æ–¹æ³•ï¼’ã¤ã‚ã‚Šã¾ã™ã€‚ï¼‘ã¤ã¯åˆ†æžãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†æ–¹æ³•ã€ã‚‚ã†ä¸€ã¤ã¯é–¢æ•°ã‚’ä½¿ã†æ–¹æ³•ã§ã™ã€‚ ï¼’ï¼Žé–¢æ•°ã«ã‚ˆã‚‹ç›¸é–¢ä¿‚æ•°ã®æ±‚ã‚æ–¹ã€‚ ï¼‘çµ„ã ã‘ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã«ã¤ã„ã¦ç›¸é–¢ä¿‚æ•°ã‚’æ±‚ã‚ã‚‹ã®ã§ã‚ã‚Œã°ã€é–¢æ•°ã‚’ä½¿ã†ã®ãŒç°¡å˜ã§ã™ã€‚ã€€ä¸‹ã®ã‚ˆã†ãªåŒ—åŠçƒå„åœ°ç‚¹ã§ã®ï¼‘æœˆã¨ï¼—æœˆã®å¹³å‡æ°—æ¸©ã®ç›¸é–¢ä¿‚æ•°ã‚’æ±‚ã‚ã¾ã—ã‚‡ã†ã€‚
fukudamasa09 2012/08/21
excel

çµ±è¨ˆ

ã‚¨ã‚¯ã‚»ãƒ«

ã‚ã¨ã§ã‚„ã‚‹

Note

office
ãƒªãƒ³ã‚¯
buzzword(ãƒã‚ºãƒ¯ãƒ¼ãƒ‰)
æ ªå¼ä¼šç¤¾ãƒã‚ºãƒ¯ãƒ¼ãƒ‰ã¨ã—ã¦é‹å–¶ã—ã¦ã„ã‚‹ã‚µã‚¤ãƒˆã®ä¸€è¦§ã§ã™ã€‚ JavaDrive Javaã€ Pythonã€ JavaScriptãªã©ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®ç¿’å¾—ã‚’è¡Œã†ãŸã‚ã®è§£èª¬ã‚µã‚¤ãƒˆã§ã™ã€‚ä»–ã« PHP ã‚„ Rubyã€ Perlã€ Cè¨€èªžãªã©ã®è§£èª¬ã‚’è¡Œã£ã¦ã„ã‚‹ä»–ã€æ£è¦è¡¨ç¾ã‚„ã‚¨ãƒ‡ã‚£ã‚¿ã®ä½¿ã„æ–¹ãªã©é–¢ä¿‚ã™ã‚‹çŸ¥è˜ã®è§£èª¬ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ DBOnline MySQLã€ PostgreSQLã€ SQLite ãªã©ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¦ç¿’ã™ã‚‹ãŸã‚ã®ã‚µã‚¤ãƒˆã§ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã‚„å…·ä½“çš„ãªæ“ä½œæ‰‹é †ã«ã¤ã„ã¦è§£èª¬ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ãƒã‚¦ãƒ„ãƒ¼ãƒŽãƒ¼ãƒˆ Twitter ã‚„ Gmailã€ YouTube ãªã©å„ç¨®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ OfficePro Microsoft ç¤¾ã® Wordã€ Excel ã€ Access ã«é–¢ã™ã‚‹åˆ©ç”¨æ–¹æ³•ã‚„ VBA ã‚’ä½¿ã£ãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã‚’è¡Œã£ã¦ã„ã¾
fukudamasa09 2012/07/18
javascript

Office

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ã¾ã¨ã‚

programming

php

webåˆ¶ä½œ

ajax

SQL
ãƒªãƒ³ã‚¯
co-lab | ã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼å°‚ç”¨ã®ã‚³ãƒ©ãƒœãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ã‚·ã‚§ã‚¢ã‚ªãƒ•ã‚£ã‚¹
ä»•äº‹ã®å ´ã‚’ã‚·ã‚§ã‚¢ã™ã‚‹ã€‚ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã‚’å…±å‰µã™ã‚‹ã€‚åˆ¶ä½œã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ã€‚ ã©ã‚“ãªå ´æ‰€ã‚‚ã€ã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼ã®é›†ã„ã€ã‚¯ãƒªã‚¨ã‚¤ãƒ†ã‚£ãƒ“ãƒ†ã‚£ãƒ¼ã‚’é«˜ã‚ãªãŒã‚‰åˆ¶ä½œã§ãã‚‹å ´æ‰€ã«ã€‚ çµ„ç¹”ã‚„ç«‹å ´ã¨ã„ã£ãŸåž£æ ¹ã‚’è¶…ãˆãŸâ€œé›†åˆçŸ¥â€ãŒã€ä»–ã«ãªã„ã‚¯ãƒªã‚¨ã‚¤ã‚·ãƒ§ãƒ³ã‚’å¯èƒ½ã«ã—ã¦ã„ã¾ã™ã€‚ co-lab ã«ã¤ã„ã¦ NEWS co-labå…¨æ‹ ç‚¹ã€æœ€æ–°ç©ºå®¤æƒ…å ±ã€‘ 2024.09.02 co-lab æ¸‹è°·ã‚ãƒ£ã‚¹ãƒˆ co-lab ä»£å®˜å±± co-lab å¢¨ç”°äº€æ²¢ï¼šre-printing co-lab äº”åç”° with JPRE co-factory æ¸‹è°· ï¼œæ‹ ç‚¹ä¸€è¦§ï¼ž co-labäº”åç”° with JPRE ã€’141-0031 æ±äº¬éƒ½å“å·åŒºè¥¿äº”åç”°8-4-13 äº”åç”°JPãƒ“ãƒ«ãƒ‡ã‚£ãƒ³ã‚°2F æ±æ€¥æ± ä¸Šç·šï¼»å¤§å´Žåºƒå°è·¯é§… REPORT co-labäº”åç”° with JPREã‚ªãƒ¼ãƒ—ãƒ‹ãƒ³ã‚°ãƒ‘ãƒ¼ãƒ†ã‚£ãƒ¼ã‚’é–‹å‚¬ã—ã¾ã—ãŸï¼ 2024.09.02 co-lab äº”åç”°
fukudamasa09 2012/07/02
lab

ã‚·ã‚§ã‚¢ã‚ªãƒ•ã‚£ã‚¹

webãƒ‡ã‚¶ã‚¤ãƒ³

design

creator

OFFICE

èµ·æ¥

ä¸å‹•ç”£

share

studio
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
fukudamasa09 2012/07/02
Microsoft

tutorial

programming

Excel

office

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

php

XML

ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
Google Docsã®SpreadsheetãŒãƒ¤ãƒã‚¤ä»¶(1) | Office TANAKA
Google Docsã®SpreadsheetãŒãŠã‚‚ã—ã‚ã„ã§ã™ã€‚ ã‚ã€ã€Œãƒ¤ãƒã‚¤ã€ã¯ã»ã‚è¨€è‘‰ã¨ã—ã¦ã®æ„å‘³ã§ã™ã€‚ ç›®æŒ‡ã™æ–¹å‘æ€§ãŒé•ã„ã¾ã™ã‹ã‚‰ã€ç¾åœ¨ã®Excelã¨æ¯”è¼ƒã™ã‚‹ã“ã¨ã¯ã‚ã¾ã‚Šæ„å‘³ãŒã‚ã‚Šã¾ã›ã‚“ãŒã€ã¨ã‚Šã‚ãˆãšã€å®Ÿè£…ã—ã¦ã„ã‚‹ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆé–¢æ•°ã‚’æ¯”è¼ƒã—ã¦ã¿ã¾ã—ãŸã€‚ ã¾ãšã€Excel 2007ã«ã¯ã‚ã‚‹ã‘ã©ã€Google Spreadsheetã«ã¯ãªã„é–¢æ•°ã§ã™ã€‚ AMORDEGRCÂ CUBESETCOUNTÂ GAMMALNÂ NUMBERSTRINGÂ AMORLINCÂ CUBEVALUEÂ GESTEPÂ ODDFPRICEÂ AREASÂ DATEDIFÂ GETPIVOTDATAÂ ODDFYIELDÂ ASCÂ DAVERAGEÂ IMABSÂ ODDLPRICEÂ AVERAGEIFÂ DBCSÂ IMAGINARYÂ ODDLYIELDÂ AVERAGEIFSÂ DCOUNTÂ IMARGUMENTÂ PHONETICÂ BAHT
fukudamasa09 2012/05/30
Excel

google-spreadsheet

google

Spreadsheet

office

ä»•äº‹è¡“

google apps

Google Docs

filter

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
å…¥åŠ›è¦å‰‡ã®ãƒªã‚¹ãƒˆç”¨ãƒ‡ãƒ¼ã‚¿ã‚’åˆ¥ã‚·ãƒ¼ãƒˆã«ã¾ã¨ã‚ã‚‹ï¼šExcel ã‚¨ã‚¯ã‚»ãƒ«ã®ä½¿ã„æ–¹-å…¥åŠ›è¦å‰‡
å…¥åŠ›è¦å‰‡æ©Ÿèƒ½ã§ã€ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆï¼ˆãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆï¼‰ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã®ã¯ã€Excelã§äººæ°—ã®Tipsã®ã²ã¨ã¤ã§ã™ã€‚ å®Ÿå‹™ã§ã¯ã€ãƒªã‚¹ãƒˆè¡¨ç¤ºç”¨ã®ãƒ‡ãƒ¼ã‚¿ã‚’åˆ¥ã‚·ãƒ¼ãƒˆã«ã—ã¦ã€ãã®ã‚·ãƒ¼ãƒˆã‚’éžè¡¨ç¤ºã«ã—ã¦ãŠãã®ãŒã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ“ãƒªãƒ†ã‚£ãƒ»ä¿å®ˆæ€§ãªã©ã®é¢ã‹ã‚‰ãŠã™ã™ã‚ã§ã™ã€‚ ã§ã™ãŒã€ï¼»ãƒ‡ãƒ¼ã‚¿ã®å…¥åŠ›è¦å‰‡ï¼½ãƒ€ã‚¤ã‚¢ãƒã‚°âˆ’ï¼»è¨å®šï¼½ã‚¿ãƒ–âˆ’ï¼»å…ƒã®å€¤ï¼½æ¬„ã«ã€ã€Œ=ã‚·ãƒ¼ãƒˆå!ã‚»ãƒ«ç¯„å›²ã€ã¨ã„ã†é€šå¸¸ä»–ã®ã‚·ãƒ¼ãƒˆã‚’å‚ç…§ã™ã‚‹å ´åˆã®è¨˜è¿°ã‚’ã™ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“ã€‚ ã‚„ã‚ã†ã¨ã—ã¦ã‚‚ ã€ŒæŠ½å‡ºæ¡ä»¶ ãƒ‡ãƒ¼ã‚¿ã®å…¥åŠ›è¦å‰‡ã§ã€ä»–ã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã¾ãŸã¯ãƒ–ãƒƒã‚¯ã¸ã®å‚ç…§ã¯ä½¿ç”¨ã—ã¾ã›ã‚“ã€‚ã€ ã¨ã„ã£ãŸãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œè¨å®šã§ãã¾ã›ã‚“ã€‚ ã©ã†ã™ã‚Œã°ã„ã„ã®ã§ã—ã‚‡ã†ã‹ã€‚ ã“ã‚ŒãŒã€åå‰ã‚’å®šç¾©ã™ã‚‹ã“ã¨ã§å®Ÿè£…ã§ãã‚‹å‡¦ç†ã®ä¸€ä¾‹ã§ã™ã€‚
fukudamasa09 2012/04/16
Excel

*blog

Microsoft

å…¥åŠ›è¦å‰‡

tips

office

ã‚¨ã‚¯ã‚»ãƒ«

ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆ

*excel

åˆ¥ã‚·ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
Office TANAKA - ã‚·ãƒ¼ãƒˆã®æ“ä½œ[ä¿è·/è§£é™¤ã™ã‚‹]
Protectãƒ¡ã‚½ãƒƒãƒ‰ã¨Unprotectãƒ¡ã‚½ãƒƒãƒ‰ ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã‚’ä¿è·ã™ã‚‹ã«ã¯Protectãƒ¡ã‚½ãƒƒãƒ‰ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚·ãƒ¼ãƒˆã‚’ä¿è·ã—ã¾ã™ã€‚ Sub Sample07() ActiveSheet.Protect End Sub ä¿è·ã‚’è§£é™¤ã™ã‚‹ã«ã¯Unprotectãƒ¡ã‚½ãƒƒãƒ‰ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚·ãƒ¼ãƒˆã®ä¿è·ã‚’è§£é™¤ã—ã¾ã™ã€‚ Sub Sample07_2() ActiveSheet.Unprotect End Sub ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ä»˜ãã®ä¿è· ã‚·ãƒ¼ãƒˆã‚’ä¿è·ã™ã‚‹ã¨ãã¯ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã§ãã¾ã™ã€‚ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ä»˜ãã§ä¿è·ã•ã‚ŒãŸã‚·ãƒ¼ãƒˆã¯ã€è§£é™¤ã™ã‚‹ã¨ãã«ã‚‚ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ã§ã™ã€‚æ¨©é™ã‚’æŒãŸãªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¯ã‚·ãƒ¼ãƒˆã®å†…å®¹ã‚’è¦‹ã›ãŸããªã„ã¨ããªã©ã«æœ‰åŠ¹ã§ã™ãã€‚ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ä»˜ã‘ã¦ã‚·ãƒ¼ãƒˆã‚’ä¿è·ã™ã‚‹ã«ã¯ã€Protectãƒ¡ã‚½ãƒƒãƒ‰ã®å¼•æ•°Passwordã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¾ã™ã€‚æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚·ãƒ¼
fukudamasa09 2012/03/30
office

vba

excel

ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
Office TANAKA - Excel VBA Tips[ãƒ–ãƒƒã‚¯ãŒé–‹ã‹ã‚Œã¦ã„ã‚‹ã‹ã©ã†ã‹èª¿ã¹ã‚‹]
ãƒ–ãƒƒã‚¯ã‚’é–‹ãã«ã¯ã€Workbooksã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã®Openãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã„ã¾ã™ã€‚ æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ã€C:\Book1.xlsã‚’é–‹ãã¾ã™ã€‚ Sub Sample1() Workbooks.Open Filename:="C:\Book1.xls" End Sub ã¾ã£ãŸãä½•ã¦ã“ã¨ã®ãªã„å‡¦ç†ã§ã™ãŒã€ã“ã®ãƒ–ãƒƒã‚¯ã‚’ã™ã§ã«èª°ã‹ãŒé–‹ã„ã¦ã„ãŸã¨ã—ãŸã‚‰ã€ã„ã‚ã„ã‚ã¨ã€ã‚„ã£ã‹ã„ãªã“ã¨ãŒèµ·ã“ã‚Šã¾ã™ã€‚ãªãŠã€C:\Book1.xlsã¯ã€Œå…±æœ‰ãƒ–ãƒƒã‚¯ã§ã¯ãªã„ã€ã¨ã—ã¾ã™ã€‚å…±æœ‰ãƒ–ãƒƒã‚¯ã‚’èª°ãŒé–‹ã„ã¦ã„ã‚‹ã‹èª¿ã¹ã‚‹æ–¹æ³•ã¯ã€Œå…±æœ‰ãƒ–ãƒƒã‚¯ã‚’é–‹ã„ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’èª¿ã¹ã‚‹ã€ã‚’ã”è¦§ãã ã•ã„ã€‚ è‡ªå‹•çš„ã«[é€šçŸ¥]ã§é–‹ã‹ã‚Œã¦ã—ã¾ã† å…±æœ‰ãƒ–ãƒƒã‚¯ã§ã¯ãªã„æ™®é€šã®ãƒ–ãƒƒã‚¯ã‚’ã€ã™ã§ã«èª°ã‹ãŒé–‹ã„ã¦ã„ãŸã¨ãã€ãã®åŒã˜ãƒ–ãƒƒã‚¯ã‚’æ‰‹å‹•ã§é–‹ã“ã†ã¨ã™ã‚‹ã¨ã€æ¬¡ã®ã‚ˆã†ãªç¢ºèªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ è¨±ã•ã‚ŒãŸé¸æŠžè‚¢ã¯[èªã¿å–ã‚Šå°‚ç”¨]ã¨[é€šçŸ¥]ã®2ã¤ã§ã™ã€‚[èªã¿å–ã‚Šå°‚ç”¨]ãƒœã‚¿ãƒ³ã§é–‹ãã¨ã€
fukudamasa09 2012/03/26
Open

Book

office

Excel

ãƒ•ã‚¡ã‚¤ãƒ«æ“ä½œ

VBA
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸