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

[µo°Ý] ExcelÀɮצ³¿ìªk¨¾¤î§O¤H½Æ»s±NÀÉ®×±a¨«¶Ü?

ÀÉ®×­Y¦³¤W¦Ê¤W¤d­Ó»Ý­n«OÅ@, ¥ô¦ó¥Îµ{¦¡¥h³B²z³£¬O¯Ó®É¯Ó¤O,
§Ë¨ì³Ì«á¥i¯à¦Û¤v¤]¥Î¤£¤FÀÉ!!!
ÀÉ®×¥u¦s¦b¦Û¤vªºPC, °µ¦n°ò¥»µn¤J¨¾Å@§Y¥i!
­Y¬O©ñ¦b°Ïºô¨Ñ¤j®a¨Ï¥Î, ¥u­n"¥t¦s·sÀÉ"§Y¥i½Æ»s, ¨¾¤£¤F~~
¤£µM©O? ©Þ±¼¥~ºô¤ÎUSB, µLªk¤W¶Ç¶³ºÝ¤Î½Æ»sUSBºÐ,
·íµM, ¥Î¤â¾÷¤´¥i©ç·ÓºI¨ú³Ì¾÷­nªº¸ê®Æ,
©Ò¥H.....???

TOP

¦^´_ 20# n7822123

·PÁ n7822123¤j ¶O¤ß¦^ÂÐ
¦]¥Ø«e¤W¯Z¤¤¤£¤è«K¨Ï¥Î¤½¥q¹q¸£³s¥~ºô
¾\Äý±zªº¤j§@
«Ý¤U¯Z«á¤p§Ì¥²©w¥J²Ó¾\Äý±zªº¤j§@
«D±`·PÁÂ
±o·N®É§C½Õ
¥¢·N®É²H©w

TOP

¦^´_ 21# ­ã´£³¡ªL

·PÁ ­ã¤j ±zªº¦^ÂÐ

±z»¡ªº¤pªº³£©ú¥Õ

¤p§Ì­n¨¾¤î"§O¤H½Æ»s±NÀÉ®×±a¨«"¥D­n¬O
ExcelÀɮפºªºVBAµ{¦¡»P¤@¨Ç¨ç¼ÆªºÀ³¥Î
¤£Åý"§O¤H"¥i¥H»´©öªº¦¬³Î
·Q¤@¬q¾A¦Xªºvbaµ{¦¡»yªk©ÎªÌ¨ç¼Æ·f°t
¥i¯à»Ý­n´X­Ó¬P´Á¬Æ¦Ü§ó¤[
¦ý¬O­Y¤£°µ¤@¨Ç¨¾Å@"§O¤H"¦¬³Î¥u­n´X¤ÀÄÁ
·íµM¹J¨ì°ª¤â¤´¬O"¦³ªk¦³¯}"¨º¤]¥u¯à¯º¤@¯º
²¦³º³£¦³°µ¥²­nªº¨¾Å@¤F
±o·N®É§C½Õ
¥¢·N®É²H©w

TOP

¦^´_ 19# n7822123

­º¥ý«D·PÁ n7822123 ¤j±zªº¶O¤ß³Ð§@
³o´X¤Ñ«á¾Ç¾\Ū±zªº¤j§@«á¥Ñ°J´º¥õ ¤Ó¼F®`¤F
¥H¤U°ÝÃD½Ð±z¸Ñ´b

1.±N¸ê®Æ¤À¦¨"¸ê®ÆÀÉ"»P"¬d¸ßÀÉ"
  
  ©ú¥Õ,¸ÑÀ£ÁY«á¦³¬°4­ÓÀÉ®×
  ¬Ý¤£¥X¸ê®ÆÀɬO¦óºØ"Ãþ«¬"ªºÀÉ®×

2.±N¸ê®ÆÀÉÁôÂáA¥Ñ¬d¸ßÀɪº"¬d¸ßµ{¦¡"¥h§ì¸ê®ÆÀɪº¤ºªº¸ê®Æ
    PS:¥»§@¸ê®ÆÀÉ»P¬d¸ßÀÉ­n©ñ¦P¤@¸ô®|(¥i¦Û¤v³]©w¸ê®Æ§¨¦ì¸m¡A§ïµ{¦¡ªº¸ô®|§Y¥i)

  ­Y±N¸ê®ÆÀɤÄ"ÁôÂÃ"«h¸õ¥X¹ï¸Ü¤è¶ôÅã¥Ü"§ä¤£¨ì¸ê®ÆÀÉ"
©ÎªÌ¬O«á¾Ç»~·|±zªº»y·N

3.±N¸ê®ÆÀɤºªº¸ê®Æ°µÂà½X¥[±K¡A´Nºâ§O¤H®³¨ì¸ê®ÆÀɤ]µLªk¥¿±`¸ÑŪ¸ê®Æ(±ÀÂËÂন¶Ã½X)
   PS:¦]¬°¥u¬O°µ­Ó½d¨Ò¡A¥»§@¹ï¸ê®Æªº¥[±K»P¸Ñ±K°µªº«Ü²³æ¡A­n§ó½ÆÂø¥i¦Û¥Ñµo´§

½Ð°Ý­n¦p¦óÂà½X¥[±K­n¥Î¤°»ò³nÅé
  
4."¸Ñ±Kµ{¦¡"¼g¦b¬d¸ßÀɤ¤¡AÁקK§O¤H®³¨ì¸ê®ÆÀɪº¦P®É¤]®³¨ì"¸Ñ±Kµ{¦¡"

¦³¬Ý¨ì SUb¸Ñ½X()

5."¬d¸ßµ{¦¡" & "¸Ñ±Kµ{¦¡" »Ý°µÁôÂáA¤@¶}©l¤£¦bVBA¤¤
    PS:¥»§@ÁôÂõ{¦¡°µªk¡G¶×¤J¥¨¶°µ{¦¡ => °õ¦æ¶×¤Jªºµ{¦¡ => ²¾°£¶×¤Jªºµ{¦¡
6.§Q¥Î¤W­z²Ä5ÂI¤]¦³ªþ±a¥\¯à¡Aµ{¦¡"µLªk³æ¦æ°õ¦æ"¡A´î¤Öµ{¦¡³Q¯}¸Ñªº¾÷²v

¥H¤W2ÂI¬O«á¾Ç¾Ç²ßºë¶iªº¥Ø¼Ð(n¤j±z¤Ó°ª¬ñ¤F)

7.¬G·N§âµ{¦¡¼gªºÁÓÂ਱°j¡A¥[¤jµ{¦¡ªº¾\ŪÃø«×¡AVBA¥\¤O¤£¨ì¦ìªº¤H¡AµLªk¬ÝÀ´

§Ú´N¬O¨º­Ó¥\¤O¤£¨ì¦ìªº¤H

8.¦b¸ê®ÆÀÉ¥[¤JÅçÃÒ¸ê®Æ¡A·íÅçÃÒ¤£¹L®É¡A"¬d¸ßµ{¦¡"¨ú®ø°õ¦æ
    PS:¥»§@·|ÅçÃÒ¹q¸£ªºµn¤J±b¸¹¡A­Y»P¸ê®ÆÀɤ£²Å¡A«hµLªk¬d¸ß
¦³±NA1Àx¦s®æadmin delete
¸õ¥X¹ï¸Ü¤è¶ô¥¼³Q±ÂÅv¨Ï¥Î¦¹ÀÉ®×
±o·N®É§C½Õ
¥¢·N®É²H©w

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD