[B! VBA] kkotyyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kkotyy id:kkotyy

VBAã«é–¢ã™ã‚‹kkotyyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

${{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}}

ã€VB.NETã€‘VB.NET ã‹ã‚‰ Excel ã® COM ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ“ä½œã™ã‚‹å ´åˆã®æ³¨æ„ç‚¹
VB.NET ã‹ã‚‰ Excel ã® COM ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ“ä½œã™ã‚‹éš›ã« COM ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’é©åˆ‡ã«è§£æ”¾ã—ãªã„ã¨ï¼ŒExcel ã®ãƒ—ãƒã‚»ã‚¹ãŒæ£ã—ãçµ‚äº†ã—ãªã„ã€‚ Excel ã®ãƒ—ãƒã‚»ã‚¹ãŒæ£ã—ãçµ‚äº†ã™ã‚‹ãŸã‚ã® Excel COM ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®å–ã‚Šæ‰±ã„æ–¹æ³•ã‚’è§£èª¬ã™ã‚‹ã€‚ ã¾ãšã¯æ¬¡ã®ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã‚’ Windows Form ã®ãƒœã‚¿ãƒ³ã‚¯ãƒªãƒƒã‚¯ã‚¤ãƒ™ãƒ³ãƒˆã«è¨˜è¿°ã—ã¦å®Ÿè¡Œã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ â€» Excel COM ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã™ã‚‹ãŸã‚ã«ã¯ï¼ŒMicrosoft Excel 11.0 Object Library ã®å‚ç…§è¨å®šãŒå¿…è¦ã§ã™ï¼ˆExcel 2003 ã®å ´åˆï¼‰ã€‚
kkotyy 2011/03/17
excel

VBA
ãƒªãƒ³ã‚¯
VBAã§ã®æ”¹è¡Œã‚³ãƒ¼ãƒ‰å¤‰æ›
ã‚»ãƒ«å†…ã§æ”¹è¡Œã™ã‚‹ã«ã¯ã€æ”¹è¡Œã—ãŸã„ä½ç½®ã§Alt+Enterã‚ãƒ¼ã‚’æŠ¼ã—ã¾ã™ã€‚ ã“ã®ã¨ãã€å…¥åŠ›ã•ã‚Œã‚‹æ”¹è¡Œã‚³ãƒ¼ãƒ‰ã¯0A(LF)ã§ã™ã€‚Windowsã§ä½¿ã‚ã‚Œã¦ã„ã‚‹ä¸€èˆ¬çš„ãªæ”¹è¡Œã‚³ãƒ¼ãƒ‰ã¯0D 0A(CRLF)ã§ã™ã€‚ æ¬¡ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã§ç¢ºèªã—ã¦ã¿ã¾ã—ãŸã€‚ Sub Sample1() Dim buf As String, dmp As String, i As Long buf = Range("B2").Text For i = 1 To LenB(buf) dmp = dmp & Hex(AscB(MidB(buf, i, 1))) & " " Next i MsgBox dmp End Sub Excelã¯æ–‡å—ãƒ‡ãƒ¼ã‚¿ã‚’Unicodeã§ç®¡ç†ã—ã¦ã„ã¾ã™ã€‚å…¥åŠ›ã—ãŸãã‚Œãžã‚Œã®æ–‡å—ã«è©²å½“ã™ã‚‹æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯æ¬¡ã®é€šã‚Šã§ã™ã€‚ ç”° : 0x7530 ä¸ : 0x4E2D 1ã€€: 0x0031 2ã€€: 0x0032 3ã€€:
kkotyy 2011/03/07
ã‚»ãƒ«å†…ã®æ”¹è¡Œã‚³ãƒ¼ãƒ‰ã¯0A(LF)

excel

VBA
ãƒªãƒ³ã‚¯
Bulk Loading Tasks - Slow in Project Developer
kkotyy 2011/03/07
Task.AddãŒé…ã„ã¨ãã®å¯¾å¿œã€‚Application.ScreenUpdateing=falseãŒã‚ãƒ¼ã‹ã€‚

VBA

msproject
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (2)

VBAã«é–¢ã™ã‚‹kkotyyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (2)

VBAã«é–¢ã™ã‚‹kkotyyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ã€VB.NETã€‘VB.NET ã‹ã‚‰ Excel ã® COM ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ“ä½œã™ã‚‹å ´åˆã®æ³¨æ„ç‚¹

VBAã§ã®æ”¹è¡Œã‚³ãƒ¼ãƒ‰å¤‰æ›

Bulk Loading Tasks - Slow in Project Developer

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (2)

VBAã«é–¢ã™ã‚‹kkotyyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ã€VB.NETã€‘VB.NET ã‹ã‚‰ Excel ã® COM ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ“ä½œã™ã‚‹å ´åˆã®æ³¨æ„ç‚¹

VBAã§ã®æ”¹è¡Œã‚³ãƒ¼ãƒ‰å¤‰æ›

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹