¥ª¡¼¥È¥¯¥ê¥Ã¥¯¤òÌܻؤ·¤Æ

UWSC¤Çºî¤Ã¤¿¥¹¥¯¥ê¥×¥È¤Ç¤É¤³¤Þ¤Ç¡¢¥ª¡¼¥È¤Ë¤Ç¤­¤ë¤«¡¢¸¡¾Ú¤¹¤ë¥µ¥¤¥È¤Ç¤¹¡£

¥¹¥Ý¥ó¥µ¡¼¥µ¥¤¥È

¾åµ­¤Î¹­¹ð¤Ï£±¥ö·î°Ê¾å¹¹¿·¤Î¤Ê¤¤¥Ö¥í¥°¤Ëɽ¼¨¤µ¤ì¤Æ¤¤¤Þ¤¹¡£¿·¤·¤¤µ­»ö¤ò½ñ¤¯»ö¤Ç¹­¹ð¤¬¾Ã¤»¤Þ¤¹¡£

ÈËÀ¹¤á¡¼¤ë¤Ç¤â¤Ç¤­¤Þ¤·¤¿¡£

ÈËÀ¹¤á¡¼¤ë¤Ç¤â¤Ç¤­¤Þ¤·¤¿¡£

ͧ¿Í¤«¤éTEL¤¬¤¢¤ê¤Þ¤·¤¿¡£

ǧ¾Ú²èÁüÊݸ¤Ç²èÁüǧ¾Ú¤ò¥¯¥ê¥¢¤¹¤ë¡£»ä¤Ï¡¢¡ÖKING OF READMAIL¡×¤Ç»î¤·¤Æ¤ß¤Þ¤·¤¿¤¬
ͧ¿Í¤Ï¡¢¡ÖÈËÀ¹¤á¡¼¤ë¡×¤Ç¤â¤Ç¤­¤¿¤½¤¦¤Ç¤¹¡£

¤½¤ì¤Ë²èÁüÊݸ¤Ç¥¯¥ê¥¢¤Ç¤­¤ë¡¢¤Ç¤­¤Ê¤¤¤Ï¡¢¤¹¤°¤ËȽÃǤǤ­¤ë¤è¤¦¤Ç¤¹¡£

¤Ä¤Þ¤ê¡¢Ç§¾Ú²èÁü¤¬¡Ö£²£±£²£±¡×¡¢¡Ö£³£´£³£´¡×¤Ê¤É¾ì¹çº¸²èÁü¤È±¦²èÁü¤¬Æ±¤¸²èÁü¤ò»ÈÍѤ·¤Æ¤¤¤ë¥µ¥¤¥È¤Ïޤ²èÁüÊݸ¤Ç¥¯¥ê¥¢¤Ç¤­¤ë¤è¤¦¤Ç¤¹¡£

ͧ¿Í¤Ïޤ¡ÖÈËÀ¹¤á¡¼¤ë¡×¤Î²èÁüÊݸ¤Ë°ì»þ´Ö¤«¤«¤é¤Ê¤«¤Ã¤¿¤½¤¦¤Ç¤¹¡£
¤½¤ì¤Ë¡¢¡ÖKING OF READMAIL¡×¤ÈÈæ¤Ù¤Æ¡¢¡ÖÈËÀ¹¤á¡¼¤ë¡×¤Ï²èÁüǧ¾Ú¤¬£²¡¢£³ÅÙ¸½¤ì¤ë»ö¤¬¤¢¤ë¤½¤¦¤Ç¤¹¤Î¤Ç¡¢¤«¤Ê¤êÊØÍø¤Ë¤Ê¤Ã¤¿¤½¤¦¤Ç¤¹¡£

¡ÖÈËÀ¹¤á¡¼¤ë¡×¤Î²ñ°÷¤ÎÊý¤Ïޤ°ìÅÙ¤ª»î¤·¤¯¤À¤µ¤¤¡£Ã¢¤·¡¢¥¢¥«¥¦¥ó¥ÈÄä»ß¤Ë¤Ê¤Ã¤Æ¤â¡¢¤Ê¤ó¤éÀÕǤ¤Ï¡¢É餤¤Þ¤»¤ó¡£³Æ¼«¤ÎȽÃǤǤɤ¦¤¾¡£

KING OF READMAIL ²èÁüǧ¾Ú

KING OF READMAIL ǧ¾Ú²èÁüÊݸ

KING OF READMAIL²èÁüǧ¾Ú¥¯¥ê¥¢Ãפ·¤Þ¤·¤¿¡£¤È¤³¤í¤¬¡¢Â¾¤Î¥µ¥¤¥È¤Ç¤Ï¡¢¤Ç¤­¤Þ¤»¤ó¡£
¤¤¤Ã¤¿¤¤¤¤¤¯¤Ä¤Î²èÁü¤¬Êݸ¤µ¤ì¤Æ¤¤¤ë¤Î¤Ç¤·¤ç¤¦¤«¡£¤Á¤Ê¤ß¤ËË¿¥µ¥¤¥È¤Ç¤Ï¡¢896¤Î²èÁü¤ò¤Û¤¾¤ó¤·¤Æ¤â¡¢°ìÃפ¹¤ë²èÁü¤¬¤Ç¤Þ¤»¤ó¤Ç¤·¤¿¡£9900¤Î²èÁü¤¬¤¢¤ë¤Î¤Ç¤·¤ç¤¦¤«¡£
inbox-URL¤òÊѹ¹¤¹¤ì¤Ð¡¢Â¾¤Î¥µ¥¤¥È¤Ç¤â±þÍѤǤ­¤ë¤È»×¤¤¤Þ¤¹¡£¤ª²Ë¤ÊÊý¤Ï¡¢¥Á¥ã¥ì¥ó¥¸¤·¤Æ²¼¤µ¤¤¡£

//king of Mail¥ª¡¼¥×¥ó//
public IE
public IE2
public se
public s
public ke[4]

IE = CREATEOLEOBJ("InternetExplorer.Application")
IE.visible = true
IE.navigate("http://kingmail.jp/pages/inbox.php")

BusyWait(ie)

//¼õ¿®È¢¡¡Open//

inbox()

exitexit

PROCEDURE inbox()

While True
for s = 0 to (IE.Document.links.length- 1)
ifb pos("runner.php?IM=", IE.document.links[s].href) > 0
IE2 = CREATEOLEOBJ("InternetExplorer.Application")
IE2.visible = true
IE2.navigate(IE.document.links[s].href)
msg_open()
endif
next
Wend
FEND

//¥á¡¼¥ëÆÉ¤ß¼è¤ê

Procedure msg_open()
BusyWait(ie)
While True
sleep(0.2)
COM_ERR_IGN¡¡¡¡//COM¥¨¥é¡¼Ìµ»ë
if IE2.document.title="Message" then BREAK
COM_ERR_RET¡¡¡¡//¥¨¥é¡¼½èÍýÉüµ¢
Wend

for ss=0 to IE2.Document.links.length-1
¡¡ ifb pos("runner.php?EA=", IE2.document.links[ss].href) > 0
¡¡¡¡IE2.navigate(IE2.document.links[ss].href)
¡¡¡¡¡¡timer()
IE2.Quit
break
¡¡ endif
next

FEND

//timeȽÄê

Procedure timer()
BusyWait(ie)
sleep(1)
kn=0
sleep(1)

//ǧ¾Ú¿ô»ú¤Îº¸£²Ê¸»ú¤òÇÛÎó¤ËÆþ¤ì¤Þ¤¹¡£

for ss=0 to IE2.Document.links.length-1
¡¡ifb pos("runner.php?KE=", IE2.document.links[ss].href) > 0
ke[kn]¡¡=COPY(IE2.document.links[ss].innerText,2,2)
// msgbox(ke[kn])
kn=kn+1
¡¡endif
next
//

//ǧ¾Ú¿ô»ú¤Î²èÁü¤ò¸¡º÷¤·¤Þ¤¹¡£

for i=0 to 4
// ǧ¾Ú¿ô»ú¤Î¥Õ¥¡¥¤¥ë̾¤ò¥ï¥¤¥ë¥É¥«¡¼¥É¤ÇÃê½Ð

ge=GETDIR("D:\uwsc41a\Readmail\img\king",ke[i]+"-?.bmp")

// ǧ¾Ú¿ô»ú¤Î¥Õ¥¡¥¤¥ë̾¤¬¤¢¤ë¾ì¹ç²èÁü¾È¹ç¤¹¤ë¡£

ifb ge<>0 then
¡¡for a=1 to ge
//fukidasi(ke[i]+"-"+a)
¡¡ifb CHKIMG("D:\uwsc41a\Readmail\img\king\"+ke[i]+"-"+a+".bmp")=TRUE then
//¡¡msgbox("hit "+ke[i]+"-"+a)
// CTRLWIN(GETID(GET_ACTIVE_WIN), CLOSE)
¡¡exit
¡¡endif
¡¡next
¡¡endif
next

// ǧ¾Ú¿ô»ú¤Î¥Õ¥¡¥¤¥ë̾¤¬¤Ê¤¤¾ì¹ç²èÁüÅÐÏ¿¤¹¤ë¡£

¡¡f¡¡=¡¡input("ǧ¾Ú²èÁüº¸Â¦¤Î¿ô»ú¤òÆþÎϤ·¤Þ¤¹")

ge=GETDIR("D:\uwsc41a\Readmail\img\king",f+"-?.bmp")
fukidasi(ge)
//
sleep(0.5)

//¤ª»È¤¤¤Î¥Ö¥é¥¦¥¶¤ÎÀßÄê¤Ë¤è¤ê¡¢ofx¡¡ofy ¤Ï¡¢Å¬µ¹Êѹ¹¤·¤Æ²¼¤µ¤¤¡£

¡¡id=GETID(GET_FROMPOINT_WIN)
¡¡¡¡ofx = 400 - STATUS(id, ST_CLX)
¡¡¡¡ofy = 260 - STATUS(id, ST_CLY)

//¡¡²èÁü¤ÎÊݸ¾ì½ê¤Ï¡¢Å¬µ¹ÀßÄꤷ¤Æ²¼¤µ¤¤¡£

¡¡SAVEIMG("D:\uwsc41a\Readmail\img\king\"+f+"-"+(ge+1),GETID(GET_FROMPOINT_WIN),ofx,ofy,110,110,0)
¡¡¡¡sleep(1)
FEND

//
Procedure BusyWait(ie)
repeat
Sleep(0.5)
until (! ie.busy) and (ie.readyState=4)
Fend

¥ê¡¼¥É¥á¡¼¥ë¥¯¥ê¥Ã¥¯

¥ê¡¼¥É¥á¡¼¥ë¥¯¥ê¥Ã¥¯
ÇÛ¿®Î̤襤¥µ¥¤¥È¤ò°ì¤Ä¤Î¥¹¥¯¥ê¥×¥È¤ËÁȤ߹þ¤ó¤Ç¤ß¤Þ¤·¤¿¡£

¢¨¡¡¥í¥°¥¤¥ó¥¨¥é¡¼¤¬¡¢½Ð¤ë¾ì¹ç¤Ïޤ¼êư¤Ç¥í¥°¥¤¥ó¤·¤Æ¤ª¤­¤Þ¤¹¡£

¢¨¡¡INBOX-URL,PTC-URL¤Ï¡¢¤½¤ì¤¾¤ì¤Î¥µ¥¤¥È¤ÎURL¤ò½ñ¤­¹þ¤ß¤Þ¤¹¡£
¢¨¡¡±ÜÍ÷ºÑ¤ß¡¢µ¬Äê¤Î¥¯¥ê¥Ã¥¯¡¢¤Ê¤É¤Î¥á¥Ã¥»¡¼¥¸¤Ï¡¢¥µ¥¤¥È¤Ë¹ç¤ï¤»¤Þ¤¹¡£
¢¨¡¡Ç§¾Ú¤Ê¤·¡¢¥µ¥¤¥È¤ËÂбþ¤·¤Æ¤¤¤Þ¤¹¡£
¢¨¡¡ËÜÅö¤ÏޤÊÂÎó½èÍý¤ò¼Â¸½¤·¤¿¤¤¤Î¤Ç¤¹¤¬¡£

-----------------------------------------------------------

public IE
public IE2
public se
public s
public c
public a

public x[2][6]=_
"ID","Pass","INBOX-URL","±ÜÍ÷ºÑ¤ß¤Ç","µ¬Äê¤Î¥¯¥ê¥Ã¥¯¿ô","PTC-URL","¥Ú¥¤¥É¥¯¥ê¥Ã¥¯¹­¹ð¤¬¤´¤¶¤¤¤Þ¤»¤ó¡£",_
"ID","Pass","INBOX-URL","¥³¥Á¥é","¤³¤Î¹­¹ð¤Ïµ¬Äê¤Î¥¯¥ê¥Ã¥¯¿ô¤Ë㤷¤Æ¤¤¤Þ¤¹¡£","PTC-URL","¿½¤·Ìõ¤´¤¶¤¤¤Þ¤»¤ó",_
"ID","Pass","INBOX-URL","Êó½·¤ò¼õ¤±¤º¤Ë","Êó½·¤ò¼õ¤±¤º¤Ë","PTC-URL","¸½ºß±ÜÍ÷¤Ç¤­¤ë¹­¹ð¤Ï¤¢¤ê¤Þ¤»¤ó"

IE = CREATEOLEOBJ("InternetExplorer.Application")
IE.visible = true

for a=0 to 2
IE.navigate(x[a][2])

BusyWait(ie)

//ID ½ñ¤­¹þ¤ß//

se=IE.document.body.innertext
ifb POS("²ñ°÷ID",se)>0 then
IE.document.forms[0].elements[1].value = x[a][0]
IE.document.forms[0].elements[2].value = x[a][1]
IE.document.forms[0].elements[5].click()
endif
//exitexit
BusyWait(ie)
sleep(2)
//¼õ¿®È¢¡¡Open//
inbox()
ptc()
next
CTRLWIN(GETID(GET_ACTIVE_WIN), CLOSE)
exitexit

//
//

PROCEDURE inbox()
BusyWait(ie)
sleep(1)
c=0
for s = 0 to (IE.Document.links.length- 1)
ifb pos("runner.php?IM=", IE.document.links[s].href) > 0
c=c+1
¡¡IE.document.forms[0].elements[c+2].click()
sleep(2)
//IELINK(IE,IE.document.links[s].href)
IE2 = CREATEOLEOBJ("InternetExplorer.Application")
IE2.visible = true
IE2.navigate(IE.document.links[s].href)
msg_open()
endif
next
if c<>0 then IE.document.forms[0].elements[2].click()
sleep(2)
FEND

//¥á¡¼¥ëÆÉ¤ß¼è¤ê
Procedure msg_open()
BusyWait(ie)
sleep(4)
//IE2 = GETACTIVEOLEOBJ("InternetExplorer.Application","Message")
for ss=0 to IE2.Document.links.length-1
¡¡ifb pos("runner.php?EA=", IE2.document.links[ss].href) > 0
¡¡¡¡IE2.navigate(IE2.document.links[ss].href)
¡¡¡¡¡¡timer()
CTRLWIN(GETID(GET_ACTIVE_WIN), CLOSE)
break
¡¡endif
next
FEND

//timeȽÄê
Procedure timer()
BusyWait(ie)
sleep(5)
se=IE2.document.body.innertext
if POS(x[a][3],¡¡se)>0 then exit
if POS(x[a][4],¡¡se)>0 then exit

COM_ERR_IGN¡¡¡¡//COM¥¨¥é¡¼Ìµ»ë
Fr=IE2.Document.Frames("timerfrm")
COM_ERR_RET¡¡¡¡//¥¨¥é¡¼½èÍýÉüµ¢
COM_ERR_IGN¡¡¡¡//COM¥¨¥é¡¼Ìµ»ë
se=Fr.document.body.innertext
COM_ERR_RET¡¡¡¡//¥¨¥é¡¼½èÍýÉüµ¢

While True
COM_ERR_IGN¡¡¡¡//COM¥¨¥é¡¼Ìµ»ë
se=Fr.document.body.innertext
COM_ERR_RET¡¡¡¡//¥¨¥é¡¼½èÍýÉüµ¢
////msgbox(COPY(se,pos("point",se)+5,4))
if POS("²Ã»»¤µ¤ì¤Þ¤·¤¿",se)<>0 then BREAK
sleep(1)
Wend

FEND

PROCEDURE ptc()
While True
IE.navigate(x[a][5])
BusyWait(ie)
se=IE.document.body.innertext
if POS("¿½¤·Ìõ¤´¤¶¤¤¤Þ¤»¤ó",se)<>0 then BREAK
for s = 0 to (IE.Document.links.length- 1)
ifb pos("runner.php?PA=", IE.document.links[s].href) > 0
IE2 = CREATEOLEOBJ("InternetExplorer.Application")
IE2.visible = true
IE2.navigate(IE.document.links[s].href)
timer()
CTRLWIN(GETID(GET_ACTIVE_WIN), CLOSE)
break
endif
next
Wend
FEND
//
Procedure BusyWait(ie)
repeat
Sleep(0.5)
until (! ie.busy) and (ie.readyState=4)
Fend




Office2000¤ÈOffice2003¤Î¥Þ¥¯¥í

Office2000¤ÈOffice2003¤Î¥Þ¥¯¥í

Office2000¤ÈOffice2003¤Î¥Þ¥¯¥í¤Ï¡¢°ã¤¦¡©¡£¤½¤ó¤Ê»ö¤Ï¤Ê¤¤¤È»×¤¦¤Î¤Ç¤¹¤¬¡£

Á°²ó¤Î¥Þ¥¯¥í¡£¥¨¥¯¥»¥ë¤«¤éGooglemap¤ò¸Æ¤Ó½Ð¤¹¥¹¥¯¥ê¥×¥È¤Ç¤¹¤¬¡¢Í§¿Í¤ÎPC¤Ç¤Ïưºî¤·¤Ê¤¤¤È¤Î»ö¡£

¤µ¤Æ¡¢¸¶°ø¤Ï¡£¡¡

­¡¡¡Googlemap¤ÎURL¤ÇIE¤ò³«¤¯¡£
­¢¡¡¸¡º÷Áë¤Ë½»½ê¤ò½ñ¤­¹þ¤à¡£
­£¡¡¸¡º÷¥Ü¥¿¥ó¤ò²¡¤¹¡£
¤¬¡¢¥Þ¥¯¥í¤Îή¤ì¤Ç¤¹¡£

­¡¤Ï¡¢Æ°ºî¤·¤Æ¤¤¤ë¤è¤¦¤Ç¤¹¡£
­¢¤«¤é­£¤¬¡¢Æ°ºî¤·¤Æ¤¤¤Þ¤»¤ó¡£

­¡¤È­¢¤Î´Ö¤Ësleep¤òÆþ¤ì¤ë¡£¤½¤ì¤È¡¢IE.Busy¤¬µ¡Ç½¤·¤Æ¤¤¤Ê¤¤¤Î¤«¤âÃΤì¤Þ¤»¤ó¡£

¤È¤ê¤¢¤¨¤º¡¢¤½¤ì¤Ç³Îǧ¤·¤Æ¤ß¤Þ¤¹¡£







¥¨¥¯¥»¥ë¤Î½»½êÏ¿¤«¤é¡¢Google map ¤ò¸Æ¤Ó½Ð¤¹

¥¨¥¯¥»¥ë¤Î½»½êÏ¿¤«¤é¡¢Google map ¤ò¸Æ¤Ó½Ð¤¹¥¹¥¯¥ê¥×¥È¤Ç¤¹¡£
´û¸¤Î½»½êÏ¿¤Ë¥Þ¥¯¥í¤òÁȤ߹þ¤ß¤Þ¤·¤¿¡£

-------------------------------------------

¡¡¡¡r = Target.Row
c=3
If Cells(r, c) <> "" And Target.Column = c Then

Set IE = New InternetExplorer
IE.Visible = True
IE.Navigate ("http://maps.google.co.jp/maps?hl=ja&tab=wl")

Do While IE.Busy = True
DoEvents
Sleep (100)
Loop

IE.Document.forms(0).elements(3).Value = Cells(r, c)
IE.Document.forms(0).elements(5).Click

End If
-------------------------------------------------------

¡¡Worksheet_SelectionChange¥¤¥Ù¥ó¥È¤Ë¥Þ¥¯¥í¥¹¥¯¥ê¥×¥È¤ò½ñ¤¯¡£
c=3 ¤³¤ì¤Ï¡¢½»½êÏ¿¤Î¥·¡¼¥È¤Î½»½ê¤¬¥«¥é¥à3¤Ë¤¢¤ë°Ù¤Ç¡¢
¡¡½»½êÏ¿¤Ë¹ç¤ï¤»¤ÆÊѹ¹¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£
¤³¤ì¤Ç¡¢½»½êÏ¿¤Î½»½ê¤Î¥»¥ë¤ò¥¯¥ê¥Ã¥¯¤¹¤ë¤È¡¢Google map ¤Ë½»½ê¤ÎÃϿޤ¬É½¼¨¤µ¤ì¤ëȦ¤Ç¤¹¡£
¡¡Ê»¤»¤Æ¡¢¥¢¥Ñ¡¼¥È̾¤äÉô²°Èֹ椬¡¢Æ±¤¸¥»¥ë¤Ëµ­ºÜ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤ÏÀµ¾ï¤Ëưºî¤·¤Þ¤»¤ó¡£

¡¡Worksheet_SelectionChange¥¤¥Ù¥ó¥È¤Ï¡¢Ìñ²ð¤Ê¥¤¥Ù¥ó¥È¤Ç¤¹¡£¿§¡¹À©¸æ¤ò²Ã¤¨¤Þ¤»¤ó¤È
¡¡»×¤ï¤Ì¾ì¹ç¤Ë¥Þ¥¯¥í¤¬Æ°¤­¤À¤·¤Þ¤¹¡£


¼¡¤Î¥Ú¡¼¥¸

FC2Ad

FC2¥Ö¥í¥° ž¿¦