ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] VBA§ì¨ú³øªíºÃ°Ý

[µo°Ý] VBA§ì¨ú³øªíºÃ°Ý

³Ìªñµo²{ §Ú­n§ìªº³øªí ¥²¶·¥ý¨Ï¥ÎEXCELªºWEBµn¤J ¤~¥i¥H§ì¤J¸ê®Æ
¹êÅç1.  EXCEL¤£µn¤J  IEµn¤J  µ²ªG §ì¤£¨ì¸ê®Æ
        2.   EXCELµn¤J      IE¤£µn¤J  µ²ªG §ì±o¨ì¸ê®Æ


½Ð°Ý¦³¤H¦³¹J¹L³o°ÝÃD¶Ü!!??
§Ú¶¶¹DPO¥Xµ{¦¡½X
  1. function UserId_onkeydown() {
  2.   if (window.event.keyCode == 13)
  3.     document.forms[0].pUserPWD.focus();
  4. }
  5. function Password_onkeydown() {
  6.   if (window.event.keyCode == 13)
  7.     document.forms[0].btn1.focus();
  8. }
  9. function fSubmit(){  
  10.     var str =document.forms[0].pUserID.value;
  11.     var stri =document.forms[0].pUserPWD.value;
  12.     var Chgstr ="";
  13.     var Chgstri ="";
  14.     for (i = 0; i<=str.length; i++){
  15.       if (str.charCodeAt(i) >= 65281 && str.charCodeAt(i) <= 65374){
  16.         Chgstr = Chgstr + String.fromCharCode(str.charCodeAt(i) - 65248);
  17.       }else{
  18.         Chgstr += str.substr(i,1);
  19.       }
  20.     }
  21.     for (i = 0; i<=stri.length; i++){
  22.       if (stri.charCodeAt(i) >= 65281 && stri.charCodeAt(i) <= 65374){
  23.         Chgstri = Chgstri + String.fromCharCode(stri.charCodeAt(i) - 65248);
  24.       }else{
  25.         Chgstri += stri.substr(i,1);
  26.       }
  27.     }
  28.     document.forms[0].pUserID.value = Chgstr;
  29.     document.forms[0].pUserPWD.value = Chgstri;
  30.     document.forms[0].submit();
  31. }
  32. //-->
  33. </SCRIPT>

  34. <STYLE type=text/css>P {
  35.         FONT-WEIGHT: 300
  36. }
  37. </STYLE>

  38. <META name=GENERATOR content="MSHTML 8.00.6001.19170"></HEAD>
  39. <BODY bgColor=#eeeeee>
  40. <CENTER><BR>
  41. <FORM method=post action=C_PIPAS011_NEW><INPUT value=N type=hidden name=pINIT>
  42. <INPUT type=hidden name=pURL>
  43. <P align=center><FONT color=red><STRONG>²Ä¤@¦¸µn¤JªÌ¡A±K½X¬°¨­¥÷ÃÒ¦r¸¹«á¥|½X</STRONG></FONT></P>
  44. <TABLE border=1 cellSpacing=1 cellPadding=3 width=320 bgColor=#c0c0c0 height=136
  45. cellspacing?2?>
  46.   <TBODY>
  47.   <TR height=25 bgColor=#9999ff>
  48.     <TD height=23 width="35%" align=middle>±b ¸¹:&nbsp;&nbsp;</TD>
  49.     <TD height=23 width="65%" align=left>&nbsp;&nbsp;<INPUT
  50.       onkeydown="return UserId_onkeydown()" maxLength=5 size=15
  51.   name=pUserID></TD></TR>
  52.   <TR height=25 bgColor=#9999ff>
  53.     <TD height=23 width="35%" align=middle>±K ½X:&nbsp;&nbsp;</TD>
  54.     <TD height=23 width="65%" align=left>&nbsp;&nbsp;<INPUT
  55.       onkeydown="return Password_onkeydown()" maxLength=6 size=8 type=password
  56.       name=pUserPWD></TD></TR>
  57.   <TR height=25 bgColor=#9999ff>
  58.     <TD height=60 colSpan=2 align=middle><INPUT onclick=fSubmit() value=µn¤J type=button name=btn1>
  59.   </TD></TR></TBODY></TABLE></FORM></CENTER>
½Æ»s¥N½X

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD