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

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

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

½Ð°Ý¦U¦ì¤j¤j,¦³¥i¯à¥i¥H¿ì¨ì¶Ü?
PKKO

¦^´_ 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

¦^´_ 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

¦^´_ 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

ÀÉ®×­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

¥»©«³Ì«á¥Ñ n7822123 ©ó 2020-7-12 02:14 ½s¿è

¦^´_ 19# n7822123


©êºp¡A¤W¤@©«¦n¹³¶Ç¨ì´ú¸ÕÀÉ¡A°õ¦æ¦³°ÝÃD

¥H¦¹ªþ¥ó¬°¥D~~~¤w¸gºÉ¥i¯àÂõ{¦¡½X¤F ^.^"¡A µo²{´Nºâ§A§Q®`!!!

¥u­n[A1]Àx¦s®æ¿é¤J "admin" §Y¥i¥¿±`¬d¸ß  ("admin"¬°¸ê®ÆÀɤ¤©Ò³]©wªº"¤¹³\¬d¸ß±b¸¹")  


¨¾¤î¸ê®Æ³Q±a¨«(½d¨Ò).rar (85.82 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2020-7-11 22:18 ½s¿è

¦^´_ 18# n7822123


¦³¯}ºì¡AÁÙ¬O¨ÓÀu¤Æ¤@¤Uµ{¦¡ ^.^¡A¶¶«K¦Û±À~~

­«­z¤@¤U­ì²z


1.±N¸ê®Æ¤À¦¨"¸ê®ÆÀÉ"»P"¬d¸ßÀÉ"
2.±N¸ê®ÆÀÉÁôÂáA¥Ñ¬d¸ßÀɪº"¬d¸ßµ{¦¡"¥h§ì¸ê®ÆÀɪº¤ºªº¸ê®Æ
    PS:¥»§@¸ê®ÆÀÉ»P¬d¸ßÀÉ­n©ñ¦P¤@¸ô®|(¥i¦Û¤v³]©w¸ê®Æ§¨¦ì¸m¡A§ïµ{¦¡ªº¸ô®|§Y¥i)
3.±N¸ê®ÆÀɤºªº¸ê®Æ°µÂà½X¥[±K¡A´Nºâ§O¤H®³¨ì¸ê®ÆÀɤ]µLªk¥¿±`¸ÑŪ¸ê®Æ(±ÀÂËÂন¶Ã½X)
   PS:¦]¬°¥u¬O°µ­Ó½d¨Ò¡A¥»§@¹ï¸ê®Æªº¥[±K»P¸Ñ±K°µªº«Ü²³æ¡A­n§ó½ÆÂø¥i¦Û¥Ñµo´§
4."¸Ñ±Kµ{¦¡"¼g¦b¬d¸ßÀɤ¤¡AÁקK§O¤H®³¨ì¸ê®ÆÀɪº¦P®É¤]®³¨ì"¸Ñ±Kµ{¦¡"
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
7.¬G·N§âµ{¦¡¼gªºÁÓÂ਱°j¡A¥[¤jµ{¦¡ªº¾\ŪÃø«×¡AVBA¥\¤O¤£¨ì¦ìªº¤H¡AµLªk¬ÝÀ´
8.¦b¸ê®ÆÀÉ¥[¤JÅçÃÒ¸ê®Æ¡A·íÅçÃÒ¤£¹L®É¡A"¬d¸ßµ{¦¡"¨ú®ø°õ¦æ
    PS:¥»§@·|ÅçÃÒ¹q¸£ªºµn¤J±b¸¹¡A­Y»P¸ê®ÆÀɤ£²Å¡A«hµLªk¬d¸ß
9.¥i¥H¦b¸ê®ÆÀɳ]©w¦h­Ó±b¸¹¡A¨Ã¬°¨C­Ó±b¸¹³]¸m"¨Ï¥Î´Á­­"¡A­Y¶W¹L¨Ï¥Î´Á­­¡A«h"¬d¸ßµ{¦¡"·|¦Û°Ê"§R°£¸ê®Æ"
   PS:³o¥\¯à¥»§@¨S²K¥[¡A¯u­n§R°£¸ê®Æ¡A§A­ÌÁÙ«ç»ò´úªü~(¯º)
10.¦h³]¤@­ÓLicenseÀÉ¡A¦³¦¹Lincense«h¥i¥H¬d¸ß¸ê®Æ¡A¥i³]´Á­­¡A©w´Áµ¹¨Ï¥ÎªÌLicense (License ¥i¸j¹q¸£½s¸¹¡Bºô¥d½s¸¹)
   PS:³o­Ó­n·d«Ü³Â·Ð¡AÃiªº°µ¤F¡A¶È´£¨Ñ«ä¸ô¡A°ò¥»¤W¤j³¡¤À±M·~³nÅé³£¦³¦¹¥\¯à¡A¤º®e¤@©w¬O¸g¹LÂà½X¹Lªº"·t½X"


¬°¤FÅý§A­Ì¥i¥H´ú¸Õ¡A§Ú¤]¦Û¤v¼g¤F"«áªùµ{¦¡"
¬d¸ßÀÉ[A1]¨S¦³¸ê®Æ®É¡A¬d¸ßµ{¦¡·|§ì"¹q¸£¨Ï¥ÎªÌ±b¸¹"¥h¸ò¸ê®ÆÀɤñ¹ï
¬d¸ßÀÉ[A1]¦³¸ê®Æ®É¡A¬d¸ßµ{¦¡·|§ì[A1]Àx¦s®æ¸ê®Æ¥h¤ñ¹ï
­n¯à¥¿±`¬d¸ß¡A¥u­n[A1]Àx¦s®æ¿é¤J "admin" §Y¥i¥¿±`¬d¸ß
(¦¹¬°¸ê®ÆÀɤ¤©Ò³]©wªº"¤¹³\¬d¸ß±b¸¹")



¨¾¤î¸ê®Æ³Q±a¨«(½d¨Ò).rar (115.44 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2020-7-11 21:31 ½s¿è

¦^´_ 17# n7822123


±K½Xªº"½X" ¥´¿ù¦r¤F¡A^.^"

·|¾É­P ±K½X¸ê®ÆµLªk¥¿±`¬d¸ß~~


±K½Xªº½X¥´¿ù¦r¤F.......png

­×¥¿¦pªþ¥ó

¨¾¤î¸ê®Æ³Q±a¨«(½d¨Ò).rar (104.57 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2020-7-11 21:00 ½s¿è

¦^´_ 16# SB8926

»Ý¨D:
Ãö©ó±z©Ò´£¥Xªº ¤èªk¤@ ³]¥ßÅçÃÒÀÉ ªº¤è¦¡ ¥i§_¦A¸Ô­z©ÎªÌ¬O§_¦³µ{¦¡½X¤Î¨BÆJ¥i¨Ñ«á¾Ç°Ñ¦Ò ·PÁÂ

¼g­Ó½d¨Òµ¹§A°Ñ¦Ò¬Ý¬Ý¡A°²³]¤U¹Ï¬O«Ü­«­nªº­Ó¤H"¾÷±K¸ê®Æ"¡A­n¨¾¤î³Q±a¨«



­ì²z¦p¤U

1.±N¸ê®Æ¤À¦¨"¸ê®ÆÀÉ"»P"¬d¸ßÀÉ"
2.±N¸ê®ÆÀÉÁôÂáA¥Ñ¬d¸ßÀɪº"¬d¸ßµ{¦¡"¥h§ì¸ê®ÆÀɪº¤ºªº¸ê®Æ
    PS:¥»§@¸ê®ÆÀÉ»P¬d¸ßÀÉ­n©ñ¦P¤@¸ô®|(¥i¦Û¤v³]©w¸ê®Æ§¨¦ì¸m¡A§ïµ{¦¡ªº¸ô®|§Y¥i)
3.±N¸ê®ÆÀɤºªº¸ê®Æ°µÂà½X¥[±K¡A´Nºâ§O¤H®³¨ì¸ê®ÆÀɤ]µLªk¥¿±`¸ÑŪ¸ê®Æ(±ÀÂËÂন¶Ã½X)
   PS:¦]¬°¥u¬O°µ­Ó½d¨Ò¡A¥»§@¹ï¸ê®Æªº¥[±K»P¸Ñ±K°µªº«Ü²³æ¡A­n§ó½ÆÂø¥i¦Û¥Ñµo´§
4."¸Ñ±Kµ{¦¡"¼g¦b¬d¸ßÀɤ¤¡AÁקK§O¤H®³¨ì¸ê®ÆÀɪº¦P®É¤]®³¨ì"¸Ñ±Kµ{¦¡"
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
7.¬G·N§âµ{¦¡¼gªºÁÓÂ਱°j¡A¥[¤jµ{¦¡ªº¾\ŪÃø«×¡AVBA¥\¤O¤£¨ì¦ìªº¤H¡AµLªk¬ÝÀ´
8.¦b¸ê®ÆÀÉ¥[¤JÅçÃÒ¸ê®Æ¡A·íÅçÃÒ¤£¹L®É¡A"¬d¸ßµ{¦¡"¨ú®ø°õ¦æ
    PS:¥»§@·|ÅçÃÒ¹q¸£ªºµn¤J±b¸¹¡A­Y»P¸ê®ÆÀɤ£²Å¡A«hµLªk¬d¸ß
9.¥i¥H¦b¸ê®ÆÀɳ]©w¦h­Ó±b¸¹¡A¨Ã¬°¨C­Ó±b¸¹³]¸m"¨Ï¥Î´Á­­"¡A­Y¶W¹L¨Ï¥Î´Á­­¡A«h"¬d¸ßµ{¦¡"·|¦Û°Ê"§R°£¸ê®Æ"
    PS:³o¥\¯à¥»§@¨S²K¥[¡A¯u­n§R°£¸ê®Æ¡A§A­ÌÁÙ«ç»ò´úªü~(¯º)
10.¦h³]¤@­ÓLicenseÀÉ¡A¦³¦¹Lincense«h¥i¥H¬d¸ß¸ê®Æ¡A¥i³]´Á­­¡A©w´Áµ¹¨Ï¥ÎªÌLicense (License ¥i¸j¹q¸£½s¸¹¡Bºô¥d½s¸¹)
    PS:³o­Ó­n·d«Ü³Â·Ð¡AÃiªº°µ¤F¡A¶È´£¨Ñ«ä¸ô¡A°ò¥»¤W¤j³¡¤À±M·~³nÅé³£¦³¦¹¥\¯à¡A¤º®e¤@©w¬O¸g¹LÂà½X¹Lªº"·t½X"


¥H¤W10ÂI¦pªG³£°µªº¨¬°÷"§¹¬ü"¡A¤£¤î¥i¨¾"§g¤l"¡A"¤p¤H" ­Y¥\¤O¤£°÷¤]·í¤£¦¨"¤p¤H"¤F
¬°¤FÅý§A­Ì¥i¥H´ú¸Õ¡A§Ú¤]¦Û¤v¼g¤F"«áªùµ{¦¡"
¬d¸ßÀÉ[A1]¨S¦³¸ê®Æ®É¡A¬d¸ßµ{¦¡·|§ì"¹q¸£¨Ï¥ÎªÌ±b¸¹"¥h¸ò¸ê®ÆÀɤñ¹ï
¬d¸ßÀÉ[A1]¦³¸ê®Æ®É¡A¬d¸ßµ{¦¡·|§ì[A1]Àx¦s®æ¸ê®Æ¥h¤ñ¹ï
­n¯à¥¿±`¬d¸ß¡A¥u­n[A1]Àx¦s®æ¿é¤J "admin" §Y¥i¥¿±`¬d¸ß
(¦¹¬°¸ê®ÆÀɤ¤©Ò³]©wªº"¤¹³\¬d¸ß±b¸¹")

¥H¤UÀɮצ³¨â­Ó¬d¸ßÀÉ¡A¤º®e¬O¤@¼Ëªº¡A¥u¬O¥t¦s¦¨·s¤£¦Pª©¥»
°µ­Ó²³æªº½d¨Ò¤]ªá¤F¤£¤Ö®É¶¡¡A¤£®e©ö§r¡A¦³¾Ç¨ìªF¦èªº¤HÀ°¦£±À¤@¤U~
­ì²z¤W­±³£»¡¤F¡A¥i¦Û¦æ¬ã¨s¡A¦³²Ó¸`¤£À´¡A¤]¥iµo°Ý^.^


¨¾¤î¸ê®Æ³Q±a¨«(½d¨Ò).rar (92.2 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 2# mark15jill

¤èªk¡G
   1.³]©wÅçÃÒÀÉ¡G
       ³]©w¤@­Ó±Mªù¥Î¨ÓÅçÃÒ ¨º­ÓÀɮ׬O§_¦s¦b¨Ï¥ÎªÌ¥»¾÷¡A¦pªG¨S¦³¡Aª½±µ§R°£¡C
       A=ÀÉ®×    B=ÅçÃÒÀÉ   
        
        A¶}±Ò«á¡A¦Û°ÊŪ¨úB¡A§PÂ_¬O§_¬°©Ò³]©wªº¡C¦pªG¬O¡AÄ~Äò°õ¦æ¡C  ¦pªG¤£¬O¡Aª½±µ§R°£ÀɮסC

m¤j ±z¦n
Ãö©ó±z©Ò´£¥Xªº ¤èªk¤@ ³]¥ßÅçÃÒÀÉ ªº¤è¦¡ ¥i§_¦A¸Ô­z©ÎªÌ¬O§_¦³µ{¦¡½X¤Î¨BÆJ¥i¨Ñ«á¾Ç°Ñ¦Ò ·PÁÂ
±o·N®É§C½Õ
¥¢·N®É²H©w

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD