¥¨¥¯¥»¥ë¤Ë¤Ä¤¤¤Æ
- ¤³¤Î¥Õ¥©¡¼¥é¥à¤Ë¿·¤·¤¤¥È¥Ô¥Ã¥¯¤òΩ¤Æ¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó
- ¤³¤Î¥Õ¥©¡¼¥é¥à¤Ç¤Ï¥²¥¹¥ÈÅê¹Æ¤¬¶Ø»ß¤µ¤ì¤Æ¤¤¤Þ¤¹
Re: ¥¨¥¯¥»¥ë¤Ë¤Ä¤¤¤Æ
msg# 1.4
sayapapa1120
Åê¹Æ¿ô: 61
nobukoshi802¤µ¤ó¡£
»×¤¦¤è¤¦¤Ë¤Ç¤¤Þ¤·¤¿¡£
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
»×¤¦¤è¤¦¤Ë¤Ç¤¤Þ¤·¤¿¡£
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Re: Re: ¥¨¥¯¥»¥ë¤Ë¤Ä¤¤¤Æ
msg# 1.3.1.1
nobukoshi802
Åê¹Æ¿ô: 118
MAGIC¤Î¥í¥¸¥Ã¥¯
³°Éô¥³¡¼¥ë C=COM Set Excel Range.Value2 ÃÍ x
MAGIC¤ÎÀßÄêÃÍ
¥ª¥Ö¥¸¥§¥¯¥È OLEÊÑ¿ô
¥ª¥×¥·¥ç¥ó¡¡ S=¥×¥í¥Ñ¥Æ¥£¤ÎÀßÄê
¥×¥í¥Ñ¥Æ¥£¡¡ Value2
¾åµ¤Ç¤³¤Á¤é¤ÏÀßÄꤷ¤Æ¤¤¤Þ¤¹¡£
³°Éô¥³¡¼¥ë C=COM Set Excel Range.Value2 ÃÍ x
MAGIC¤ÎÀßÄêÃÍ
¥ª¥Ö¥¸¥§¥¯¥È OLEÊÑ¿ô
¥ª¥×¥·¥ç¥ó¡¡ S=¥×¥í¥Ñ¥Æ¥£¤ÎÀßÄê
¥×¥í¥Ñ¥Æ¥£¡¡ Value2
¾åµ¤Ç¤³¤Á¤é¤ÏÀßÄꤷ¤Æ¤¤¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Re: ¥¨¥¯¥»¥ë¤Ë¤Ä¤¤¤Æ
msg# 1.3.1
sayapapa1120
Åê¹Æ¿ô: 61
³§¤µ¤ó¡¢¤³¤ó¤Ð¤ó¤Ï¡£
Range¤ò»È¤¦¤³¤È¤Ïʬ¤«¤Ã¤¿¤Î¤Ç¤¹¤¬¡£
¤É¤ÎÍͤ˻Ȥ¦¤Î¤«Ê¬¤«¤ê¤Þ¤»¤ó¡£
¤¹¤ß¤Þ¤»¤ó¤¬¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Range¤ò»È¤¦¤³¤È¤Ïʬ¤«¤Ã¤¿¤Î¤Ç¤¹¤¬¡£
¤É¤ÎÍͤ˻Ȥ¦¤Î¤«Ê¬¤«¤ê¤Þ¤»¤ó¡£
¤¹¤ß¤Þ¤»¤ó¤¬¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Re: ¥¨¥¯¥»¥ë¤Ë¤Ä¤¤¤Æ
msg# 1.3
sayapapa1120
Åê¹Æ¿ô: 61
nobukoshi802¤µ¤ó¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¤¹¤ß¤Þ¤»¤ó¡¢COM¤ÎRange¤Ç̾Á°¤ÎÉÕ¤¤¤¿¥»¥ë¤ËÃͤò
Æþ¤ì¤ë¾ì¹ç¤Ï¡¢¤É¤Î¤è¤¦¤Ë¤¹¤ì¤Ð¤è¤í¤·¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©
Worksheets("Sheet1").Range("hogehoge").Value = 1
¤È¤«¤Ç¤¹¡£¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
¤¹¤ß¤Þ¤»¤ó¡¢COM¤ÎRange¤Ç̾Á°¤ÎÉÕ¤¤¤¿¥»¥ë¤ËÃͤò
Æþ¤ì¤ë¾ì¹ç¤Ï¡¢¤É¤Î¤è¤¦¤Ë¤¹¤ì¤Ð¤è¤í¤·¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©
Worksheets("Sheet1").Range("hogehoge").Value = 1
¤È¤«¤Ç¤¹¡£¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Re: ¥¨¥¯¥»¥ë¤Ë¤Ä¤¤¤Æ
msg# 1.2
nobukoshi802
Åê¹Æ¿ô: 118
º£²ó¤Î¾ì¹ç¤Ï¡¢COM¤è¤êExcel¤ÇbookºîÀ®¸å¡¢Excel¤ò½ªÎ»¤µ¤»¤Æ¤«¤é
uniPaas¤Î¥³¥Þ¥ó¥É¥é¥¤¥ó¤«¤é
ºîÀ®¤·¤¿Excel¤òɽ¼¨¤µ¤»¤ë¤è¤¦¤Ë¤Ê¤ë¤È»×¤¤¤Þ¤¹¡£
uniPaas¤Î¥³¥Þ¥ó¥É¥é¥¤¥ó¤«¤é
ºîÀ®¤·¤¿Excel¤òɽ¼¨¤µ¤»¤ë¤è¤¦¤Ë¤Ê¤ë¤È»×¤¤¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Re: ¥¨¥¯¥»¥ë¤Ë¤Ä¤¤¤Æ
msg# 1.1
sayapapa1120
Åê¹Æ¿ô: 61
¼«¸Ê¥ì¥¹¤Ç¤¹¡£
°õºþ¤Ï¤Ç¤¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¤¬¡¢
¥×¥ì¥Ó¥å¡¼¤Ë¤·¤¿¾ì¹ç¡¢¥Õ¥ê¡¼¥º¤·¤¿¤è¤¦¤Ê¾õÂÖ¤Ë
¤Ê¤ê¡¢¥¿¥¹¥¯¥Þ¥Í¡¼¥¸¥ã¡¼¤«¤éEXCEL.EXE¤ò½ªÎ»¤¹¤ë¤È
uniPaaS¤¬Éüµ¢¤·¤Þ¤¹¡£
²¿¤«ÀßÄ꤬ɬÍפʤΤǤ·¤ç¤¦¤«¡£
¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
°õºþ¤Ï¤Ç¤¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¤¬¡¢
¥×¥ì¥Ó¥å¡¼¤Ë¤·¤¿¾ì¹ç¡¢¥Õ¥ê¡¼¥º¤·¤¿¤è¤¦¤Ê¾õÂÖ¤Ë
¤Ê¤ê¡¢¥¿¥¹¥¯¥Þ¥Í¡¼¥¸¥ã¡¼¤«¤éEXCEL.EXE¤ò½ªÎ»¤¹¤ë¤È
uniPaaS¤¬Éüµ¢¤·¤Þ¤¹¡£
²¿¤«ÀßÄ꤬ɬÍפʤΤǤ·¤ç¤¦¤«¡£
¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
¥¨¥¯¥»¥ë¤Ë¤Ä¤¤¤Æ
msg# 1
sayapapa1120
Åê¹Æ¿ô: 61
³§¤µ¤ó¡¢¤³¤ó¤Ë¤Á¤Ï¡£
COM¤ò»È¤Ã¤Æ¥¨¥¯¥»¥ë¤òÁàºî¤·¤¿¤¤¤È¹Í¤¨¤Æ¤¤¤Þ¤¹¡£
¹Ô¤¤¤¿¤¤¤³¤È¤Ï
¡·è¤Þ¤Ã¤¿¥¨¥¯¥»¥ë¥·¡¼¥È¤Î¥ª¡¼¥×¥ó
¢¥»¥ë¤ËÃÍ¥»¥Ã¥È
£¥×¥ì¥Ó¥å¡¼
¤¥¯¥í¡¼¥º
¤Ç¤¹¡£
¢£¤Î¥á¥½¥Ã¥É¤¬¤ï¤«¤ê¤Þ¤»¤ó¡£
¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
COM¤ò»È¤Ã¤Æ¥¨¥¯¥»¥ë¤òÁàºî¤·¤¿¤¤¤È¹Í¤¨¤Æ¤¤¤Þ¤¹¡£
¹Ô¤¤¤¿¤¤¤³¤È¤Ï
¡·è¤Þ¤Ã¤¿¥¨¥¯¥»¥ë¥·¡¼¥È¤Î¥ª¡¼¥×¥ó
¢¥»¥ë¤ËÃÍ¥»¥Ã¥È
£¥×¥ì¥Ó¥å¡¼
¤¥¯¥í¡¼¥º
¤Ç¤¹¡£
¢£¤Î¥á¥½¥Ã¥É¤¬¤ï¤«¤ê¤Þ¤»¤ó¡£
¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00