[B! vba] chiqashiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

chiqashi id:chiqashi

vbaã«é–¢ã™ã‚‹chiqashiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

Accessã‹ã‚‰Excelã®å‡ºåŠ›ã«ã¤ã„ã¦
æ“ä½œã§ãã¾ã™ã€‚ VBEã®å‚ç…§è¨å®šã§Microsoft Excel ?.? ObjectLibrary(ãƒãƒ¼ã‚¸ãƒ§ãƒ³ä¸æ˜Žãªã®ã§)ã«ãƒã‚§ãƒƒã‚¯ã‚’å…¥ã‚Œã¾ã™ã€‚ Private Sub Cmd1_Click() On Error Resume Next Dim objExcelAppã€€ As Workbook Dim strExcelFileã€€As String Dim strExcelSheet As String strExcelFile = "C:\test.xls" 'ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ•ã‚¡ã‚¤ãƒ«å strExcelSheet = "sheet1"ã€€'ãƒ–ãƒƒã‚¯ã®ã‚·ãƒ¼ãƒˆå Set objExcelApp = GetObject(strExcelFile, "Excel.Sheet") 'â€»Excelã®æŒ‡å®šã‚»ãƒ«ã«å€¤ã‚’ä»£å…¥ã™ã‚‹å ´åˆ strExcelSheet.Cells(1, 1).Value = "12" 'â€»
chiqashi 2010/10/13
Access

Excel

VBA
ãƒªãƒ³ã‚¯
Sc588(2) 2001
Last Modified: 2002/01/05 23:04:48 Sc588(2) æƒ…å ±ç§‘å¦ç‰¹è«– è³‡æ–™ã€€ Excelãƒžã‚¯ãƒã¨ã¯ Excelã®æ“ä½œã‚’è‡ªå‹•çš„ã«è¡Œãªã†(è‡ªå‹•åŒ–) å˜ç´”ãªæ‰‹é †ã‚’ã€Œå†ç”Ÿã€ã™ã‚‹ã ã‘ã§ã¯ãªãï¼Œåˆ¶å¾¡æ§‹é€ ã‚’åˆ©ç”¨ã§ãã‚‹ é¸æŠž(åˆ†å²) åå¾©(ç¹°ã‚Šè¿”ã—) ãƒ—ãƒ©ã‚¹ãƒ»ã‚¢ãƒ«ãƒ•ã‚¡ ãƒ•ã‚©ãƒ¼ãƒ ã‚„ãƒ•ã‚©ãƒ¼ãƒ éƒ¨å“(ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«)ã®åˆ©ç”¨ å¤–éƒ¨ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚„ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®åˆ©ç”¨ãªã© ãã®ä»– Excelãƒžã‚¯ãƒã§ã§ãã‚‹ã“ã¨ ä¸€é€£ã®æ“ä½œã‚’è¨˜éŒ²ãƒ»å†ç¾ æ›´ã«è¤‡é›‘ãªåˆ¶å¾¡æ§‹é€ ã®è¨˜è¿° ãƒ•ã‚©ãƒ¼ãƒ ãƒ»ãƒ•ã‚©ãƒ¼ãƒ éƒ¨å“(ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«)ã®åˆ©ç”¨ å¤–éƒ¨ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚„ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®åˆ©ç”¨ Excelãƒžã‚¯ãƒã®è¨˜è¿° VBE(Visual Basic Editor)ã‚’é–‹ã æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã‚³ãƒ¼ãƒ‰ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«è¨˜è¿°ã™ã‚‹ (å‚è€ƒ) å¼•æ•°ã®ãªã„(Public)Subãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ã—ã¦è¨˜è¿°ã™ã‚‹ï¼Žå…·ä½“çš„ã«ã¯ï¼Œä»¥ä¸‹ã®ã‚ˆã†
chiqashi 2008/05/17
Excel

VBA
ãƒªãƒ³ã‚¯
MS Officeã§å½¹ç«‹ã¤VBAã®æŠ€ï¼šã“ã‚Œã ã‘ã¯è¦šãˆã¨ã‘ï¼ - builder by ZDNet Japan
ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’æ•™è‚²ã—ã€å½¼ã‚‰è‡ªèº«ã§ã¡ã‚‡ã£ã¨ã—ãŸã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¡Œãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ã“ã¨ã§ã€å½¼ã‚‰ã‹ã‚‰ã®é–‹ç™ºè¦æ±‚ã‚’æ¸›ã‚‰ã™ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã ã‚ã†ã€‚Visual Basic for Applicationsï¼ˆVBAï¼‰ã¯å¦ç¿’ã®å®¹æ˜“ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã‚ã‚‹ãŸã‚ã€ã‚³ãƒ¼ãƒ†ã‚£ãƒ³ã‚°çµŒé¨“ã®ãªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«æ•™ãˆã‚‹è¨€èªžã¨ã—ã¦ãŠå‹§ã‚ã ã€‚ã¾ãŸã€VBAã‚’ç”¨ã„ã‚‹ã“ã¨ã§ä½œæ¥ã‚’è‡ªå‹•åŒ–ã—ãŸã‚Šã€Microsoft Officeã®é€šå¸¸ã®æ©Ÿèƒ½ã§ã¯å®Ÿç¾ã§ããªã„ã‚ˆã†ãªã“ã¨ã‚‚å®Ÿç¾ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ ä»¥ä¸‹ã¯ã€åŠ¹çŽ‡ã®é«˜ã„VBAã‚³ãƒ¼ãƒ‰ã‚’è¨˜è¿°ã§ãã‚‹ãƒ¬ãƒ™ãƒ«ã«ã¾ã§ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’å°Žã„ã¦ã„ã“ã†ã¨ã„ã†å ´åˆã«åŠ›ã‚’å…¥ã‚Œã¦ãŠãã¹ãã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ä¸Šã®7ã¤ã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã§ã‚ã‚‹ã€‚ Option Explicitã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’å„ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«è¿½åŠ ã™ã‚‹ ç†Ÿç·´é–‹ç™ºè€…ã§ã‚ã£ãŸã¨ã—ã¦ã‚‚ã€ã¡ã‚‡ã£ã¨ã—ãŸã‚¿ã‚¤ãƒ—ãƒŸã‚¹ã‚’ã‚„ã‚‰ã‹ã—ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚‹ã¯ãšã ã€‚ã“ã†ã„ã£ãŸã“ã¨ã‚’æŠ€è¡“çš„ã«é¿ã‘ã‚‹ã«ã¯ã€å„
chiqashi 2008/02/18
vba
ãƒªãƒ³ã‚¯
VBAã§HTMLæ“ä½œ
0.ã¯ã˜ã‚ã« 1 IEã‚’èµ·å‹•ã¨Webãƒšãƒ¼ã‚¸è¡¨ç¤º (1)æŒ‡å®šã—ãŸWebãƒšãƒ¼ã‚¸ã‚’è¡¨ç¤º (2)ã‚¦ã‚¤ãƒ³ãƒ‰ã‚¦ã®è¨å®š (3)IEã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«æƒ…å ±æ›¸ãè¾¼ã¿1 (4)IEã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«æƒ…å ±æ›¸ãè¾¼ã¿2 (5)è¡¨ç¤ºãƒšãƒ¼ã‚¸ã®ï¼µï¼²ï¼¬å–å¾— (6)è¡¨ç¤ºãƒšãƒ¼ã‚¸ã®ã‚¿ã‚¤ãƒˆãƒ«å–å¾— (7)ãƒ•ã‚¡ã‚¤ãƒ«æƒ…å ±å–å¾—ä¾‹ 2 ãƒ•ã‚©ãƒ¼ãƒ ã‚¨ãƒ¬ãƒ¡ãƒ³ãƒˆåˆ¶å¾¡ (1)ãƒ†ã‚ã‚¹ãƒˆãƒœãƒƒã‚¯ã‚¹ã¸æ–‡å—å…¥åŠ› (2)ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒœã‚¿ãƒ³ã‚¯ãƒªãƒƒã‚¯ (3)ãƒ©ã‚¸ã‚ªãƒœã‚¿ãƒ³ã®ãƒã‚§ãƒƒã‚¯æ–¹æ³• (4)ãƒã‚§ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ãƒã‚§ãƒƒã‚¯æ–¹æ³• (5)ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆæŒ‡å®šæ–¹æ³• (6)ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆValueæ–‡å—åˆ¶å¾¡ ãƒ»æ–‡å—æ•°ãƒ»æŒ‡å®šæ–‡å—æŠ½å‡º ãƒ»å°æ–‡å—åŒ–ãƒ»å¤§æ–‡å—åŒ– ãƒ»ã²ã‚‰ãŒãªã‚’ã‚«ãƒŠã«ã€€ãƒ»ãƒ»ç‰ 3 HTMLãƒ•ã‚¡ã‚¤ãƒ«ã®æƒ…å ±å–å¾— (1)Bodyã‚¿ã‚°ã®ãƒ‡ãƒ¼ã‚¿å–å¾— (2)ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’å–å¾— (3)ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿å–å¾— (4
chiqashi 2008/02/16
vba
ãƒªãƒ³ã‚¯
Excel VBAå…¥é–€
Excel ã§ã“ã‚Œã‹ã‚‰ VBA ã‚’ä½¿ã£ã¦ã¿ãŸã„ã¨ã„ã†æ–¹ã‚’å¯¾è±¡ã«ã—ãŸ VBA å…¥é–€ã§ã™ã€‚ VBA ã¨ã¯ Visual Basic for Applications ã®ç•¥ã§ Excel ã‚„ Access ãªã©ã§åˆ©ç”¨ã§ãã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®1ã¤ã§ã™ã€‚ VBA ã‚’ä½¿ã†ã“ã¨ã§æ‰‹å‹•ã§è¡Œã£ã¦ã„ã‚‹å®šåž‹çš„ãªæ¥å‹™ãªã©ã‚’è‡ªå‹•åŒ–ã•ã›ãŸã‚Šã€ç‹¬è‡ªã®ãƒ•ã‚©ãƒ¼ãƒ ãªã©ã‚’ä½œæˆã—ã¦ Excel ã‚’ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚ˆã†ã«è¦‹ã›ã‚‹ã“ã¨ãªã©ãŒã§ãã¾ã™ã€‚ã“ã“ã§ã¯ Excel ã§ã® VBA ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦ã‚µãƒ³ãƒ—ãƒ«ã‚’ä½¿ã„ãªãŒã‚‰è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ â€» Excel ã§ãƒžã‚¯ãƒã‚’è¨˜éŒ²ã™ã‚‹æ–¹æ³•ãªã©ã«ã¤ã„ã¦ã¯ã€ŒExcelãƒžã‚¯ãƒå…¥é–€ã€ã‚’å‚ç…§ã•ã‚Œã¦ãã ã•ã„ã€‚
chiqashi 2007/08/07
excel

vba
ãƒªãƒ³ã‚¯
d-consulting.biz
This domain may be for sale!
chiqashi 2007/06/06
PowerPoint

vba
ãƒªãƒ³ã‚¯
Officeå‚è€ƒæ›¸
ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã‚„ãƒ¯ãƒ¼ãƒ‰åŸºç¤Žã‹ã‚‰ã€ã‚ªãƒ¼ãƒˆã‚·ã‚§ã‚¤ãƒ—ç”»åŸºæœ¬è¬›åº§ã¾ã§ã€ å¤šæ•°ã®ç”»åƒã¨ç´°ã‹ãªæ‰‹é †èª¬æ˜Žã€ã‚µãƒ³ãƒ—ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã§å¦ç¿’ã§ãã‚‹ãƒ¢ãƒ¼ã‚°å¦ç¿’å®¤ã€‚ å®Ÿéš›ã«æ“ä½œã‚’è¡Œã„ãªãŒã‚‰ç¢ºå®Ÿã«ç†è§£ã—ã¦ã„ãã“ã¨ãŒã§ãã¾ã™ï¼ * è¬›åº§ã‚„ç´¹ä»‹ã™ã‚‹æ©Ÿèƒ½ã«ã‚ˆã‚Šã‚µãƒ³ãƒ—ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ãŒãªã„å ´åˆã‚‚ã‚ã‚Šã¾ã™ Excel åŸºç¤Ž 1ãƒ¬ãƒƒã‚¹ãƒ³ãŒçŸæ™‚é–“ã§çµ‚äº†ã™ã‚‹ã®ã§ã€æ™‚é–“ãŒãªã„æ™‚ã«å°‘ã—ãšã¤ã§ã‚‚å‹‰å¼·ã§ãã¾ã™ã€‚ è‡ªåˆ†ã®äºˆå®šã«ã‚ã‚ã›ã¦å¦ç¿’ã—ã¦ã¿ã¾ã—ã‚‡ã†ï¼ï¼ˆå…¨9å›ž 64ãƒ¬ãƒƒã‚¹ãƒ³æŽ²è¼‰ ï¼‰ Word åŸºç¤Ž 1ãƒ¬ãƒƒã‚¹ãƒ³ãŒçŸæ™‚é–“ã§çµ‚äº†ã™ã‚‹ã®ã§ã€æ™‚é–“ãŒãªã„æ™‚ã«å°‘ã—ãšã¤ã§ã‚‚å‹‰å¼·ã§ãã¾ã™ã€‚ è‡ªåˆ†ã®äºˆå®šã«ã‚ã‚ã›ã¦å¦ç¿’ã—ã¦ã¿ã¾ã—ã‚‡ã†ï¼ï¼ˆå…¨7å›ž 67ãƒ¬ãƒƒã‚¹ãƒ³æŽ²è¼‰ï¼‰ Excel é–¢æ•° Excelã«ã¯ä¾¿åˆ©ãªé–¢æ•°ãŒå¤šæ•°ç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ é–¢æ•°ã®ä¾¿åˆ©ãªä½¿ã„æ–¹ã‚’è§£èª¬ã—ã¾ã™ï¼ ï¼ˆå…¨11å›žï¼‰ ä»•äº‹ã«å½¹ç«‹ã¤ Excel é–¢æ•° æ™®æ®µä½¿ç”¨ã—ã¦ã„ã‚‹é–¢æ•°ãŒåˆ¥ã®ä½¿ã„æ–¹ã‚‚ã§ãã‚‹ï¼Ÿï¼ ã€Žä»•äº‹ã«å½¹ç«‹ã¤ Ex
chiqashi 2006/09/18
vba

excel
ãƒªãƒ³ã‚¯
1