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

[µo°Ý] excel VBA ¦Û°Ê§ó·s¿z¿ï°ÝÃD

[µo°Ý] excel VBA ¦Û°Ê§ó·s¿z¿ï°ÝÃD

Dear all,

³Â·Ð¤j®aÀ°À°¦£
§Ú¦Û¤v°Ñ¦Òºô¸ô¤WªºVBA»yªk¼g¤F¤@¬q»yªk

·Qªk¬O¡G
1.AFÄæ¦ì¦³³]©w"¸ê®ÆÅçÃÒ¡G«Ý®Æ,«Ý¥Í²£,¥Í²£¤¤,¾÷¥x²§±`,µ²§å,¼È°±"
Noname.jpg
2021-7-21 08:55


2.AFÄæ¦ì°_ªì³]©w¬O±N"µ²§å"ªº¿ï¶µ¤Ä¿ï¨ú®ø¡C
**** ¦¹®ÉAFÄæ¦ì¤U¨ÃµL¸ê®Æ¦³"¾÷¥x²§±`"

3.­YAFÄæ¦ì¤U¡A¿ï¾Ü"µ²§å"®É¡A¦¹®ÉVBA·|¦Û°Ê¿z¿ï±¼

4.¦ýAFÄæ¦ì¤U¡A¿ï¾Ü"¾÷¥x²§±`"®É¡Aµ²ªG¤]·|³QVBA·|¦Û°Ê¿z¿ï±¼

§Ú­n«ç»ò³]©wVBA°Ñ¼Æ
1.§Æ±æ¦bAFÄæ¦ì¦b°µ¿z¿ï®É¡A¤§«e¤Ä¿ï¨ú®ø¤§¶µ¥Ø·|¦Û°Ê³Q¿z¿ï±¼¡A
2.¦ý¤§«e¥¼ÂI¿ï¹Lªº¿ï¶µ¦p³]³Æ²§±`¡A§Æ±æ¤£­n³Q®Ø¿ï¨ú®ø¡C
error.gif
2021-7-21 09:02


error.rar (21.16 KB)
Just do it.

¦^´_ 2# Andy2483
Dear Andy2483,
©êºp§Úªí¹Fªº¤£²M·¡¡A

1.¦bAFÄæ¦ì¦³³]©w"¸ê®ÆÅçÃÒ(¤U©Ô¦¡¿ï³æ)¡G«Ý®Æ,«Ý¥Í²£,¥Í²£¤¤,¾÷¥x²§±`,µ²§å,¼È°±"³o6­Ó¿ï¶µ
2.¦bAFÄæ¦ì¤U¥u¦³"«Ý®Æ,«Ý¥Í²£,¥Í²£¤¤,µ²§å"³o¨Ç¸ê°T
3.§Ú¦bAFÄæ¦ì¥Î¿z¿ïªº¤è¦¡¡A¥ý§â"µ²§å"³o¨ú®ø¤Ä¿ï±¼¡C
4.¦¹®É"µ²§å"Äæ¦ì·|³Q¦Û°ÊÁôÂñ¼¡C
5.³o®É§Ú¦bAFÄæ¦ì¤¤¡A­YÂI¿ï¤U©Ô¦¡¿ï³æ¿ï¾Ü"¾÷¥x²§±`"©Î"¼È°±"®É¡AVBA¤@¼Ë·|§â¥¦­Ìµ¹¤©¦Û°ÊÁôÂÃ

§Ú¿ý¤F¤@¬q¹Lµ{¡A·í§Ú¿ï¾Ü"«Ý®Æ"VBA¤@¼Ë·|§â¥¦­Ìµ¹¤©¦Û°ÊÁôÂÃ
111111111111111111111111.gif
2021-7-21 15:44


§Úµo²{¤j·§¬O¦]¬°·í§Ú¦b°µ-->AFÄæ¦ì¥Î¿z¿ïªº¤è¦¡¡A¥ý§â"µ²§å"³o¨ú®ø¤Ä¿ï±¼®É¡C
¦¹®ÉAFÄæ¦ì¤U¥u¦³"¥Í²£¤¤,«Ý¥Í²£,¼È°±"³o3­Ó¿ï¶µ¡A
±Nµ²§å¤Ä¿ï¨ú®ø.jpg
2021-7-21 15:44

©Ò¥H·í§Ú¦bAF¿ï¾Ü°£¤F"¥Í²£¤¤,«Ý¥Í²£,¼È°±"³o3­Ó¿ï¶µ¥~ªº¸ê°T¡A°ò¥»¤W³£·|³QVBA¦Û°ÊÁôÂÃ

§Ú¬O·Q»¡¡A¦³¬Æ»ò¤è¦¡¬O¥i¥HÅýVBA¥u»{©w§Ú²Ä¤@¦¸¨ú®øªº¿ï¶µ¡A¦Ó¨ä¥L¿ï¶µ¥X¨Ó®É¡A¬OµL§@°Êªº
Just do it.

TOP

¦^´_ 5# Andy2483
Dear Andy2483,
¦­¦w¡I·PÁ±zªº¦^ÂСI
¸Õ¹L«á¥i¥H¨Ï¥Î¡A·P®¦¡I
¥i§_±Ð§Ú¤@¤UVBA»yªk¤j·§¤º®e¬O«ç»ò°µªº©O¡H
ÁÂÁ§A¡I¡I¡I
Just do it.

TOP

¦^´_ 4# n7822123
Dear n7822123,
¦­¦w±z¦n¡A·PÁ±zªº¦^ÂСAª¾¹DÅo¡I
Thank you.
Just do it.

TOP

¦^´_ 8# Andy2483
½Ð°Ý¤@¤U¡A

If InStr(Sc & "," & Qx, Cells(i, "AF")) = 0 Then
GoTo 99 --> ³o¬O¬Æ»ò¥Î·N¡B·N«ä©O¡H
Just do it.

TOP

¦^´_ 9# Andy2483
Dear Andy2483,
­è­è´ú¸Õ¨Ï¥ÎOK¡A·P®¦Åo¡C
½Ð°Ý¤@¤U¡A­Y¶µ¥Ø¶W¹L5­Ó¥H¤Wªº¸Ü¡A
¬O§_­×­q¤U¦C»yªk§Y¥i


   Dim Qx$, Af&, Sh$, S1$, S2$, S3$, S4$, S5$,  S6$,  S7$, i&
   Af = 32
   Sh = ""
   S1 = ""
   S2 = ""
   S3 = ""
   S4 = ""
   S5 = ""
  S6 = ""
   S7 = ""
Just do it.

TOP

¦^´_ 12# Andy2483
Dear Andy2483,
·PÁ±zªº¦^ÂлP±Ð¾É¡I
Just do it.

TOP

¦^´_ 13# Andy2483

¤F¸ÑÅo¡A¯uªº«Ü·PÁ§Aªº±Ð¾É¼Ú¡I
Just do it.

TOP

¦^´_ 17# Andy2483
Dear Andy2483,
¤U¤È¦n¡I·PÁ±zªº¼ö¤ß¦^´_¼Ú¡A§Ú¦A¨Ó´ú¸Õ¬Ý¬Ý¡I
Thank you so much. ^^
Just do it.

TOP

¦^´_ 19# n7822123

Dear n7822123,
±z¦n¡I·PÁ±zªº¼ö¤ß¦^´_»P«ü¾É¼Ú¡I
©êºp°ÝÃD§Ú°Ýªº²¤¬°½ÆÂø¡C
¥D­n´N¬O±z©Ò´£¨ìªº¡G·Q¿ìªk°O¿ý "¨Ï¥ÎªÌ¤£­nªº" ¿ï¶µ
·P®¦Åo¡I
Just do it.

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD