¥xÆW³Ì¤jµ{¦¡³]­pªÀ¸sºô¯¸
½u¤W¤H¼Æ
1329
 
·|­ûÁ`¼Æ¡G245250
°Q½×¥DÃD¡G189111
Åwªï±z§K¶O¥[¤J·|­û
°Q½×°Ï¦Cªí >> office VBA / WinOS >> (¨D§U)¤ñ¹ï­«½Æªº«á±ø¥ó¦¡§R°£¡A¨Ã½Æ»s±N§R°£ªº¦æ³¡¤À¤º®e¨ì«O¯dªº
[]  
[§Ú­n¦^ÂÐ]
1
¦^À³¥DÃD ¥[¤J§ÚªºÃöª`¸ÜÃD ÀËÁ|¦¹½g°Q½× ±N´£°ÝªÌ¥[¤J­Ó¤H¶Â¦W³æ
(¨D§U)¤ñ¹ï­«½Æªº«á±ø¥ó¦¡§R°£¡A¨Ã½Æ»s±N§R°£ªº¦æ³¡¤À¤º®e¨ì«O¯dªº
»ù­È : 150 QP  ÂI¾\¼Æ:396 ¦^À³¼Æ:15

¼Ó¥D

ypyp1015
ªù¥~º~
0 2
82 10
µo°e¯¸¤º«H

¤j¯«­Ì¦n¡A¤£¦n·N«ä³Â·ÐÀ°§Ú¸Õ¸Õ¬Ý§Úªº»Ý¨D¦³¨S¦³¥i²¤Æªº¤è¦¡¡A¦pvba¡A³oÃä¥ý¸ò¤j¯«­Ì¹DÁ¡C

§Ú¥Ø«eªº§@·~¦p¤U:
¨C¤é»Ý¨t²Î¶×¥X³øªí«á¾ã¨Ö¬ö¿ý
A B C D E F G H
A~E¬O¨t²Î¶×¥X©T©w®æ¦¡¡AFGH¬O°O¿ý¥Îªº¥i¯à§t¦³¨ç¼Æ

A:¤£­«½Æ­È (¼Æ¦r)
C:¦r¦ê ¥i¯à¬°(µ¥«Ý©Îµ²§ô©Î¡K)¡A
§Ú»Ý­n¥ý¤ñ¹ïAÄæ«á¦p¦³­«½Æªº¼Æ­È¡A¦A±N­«½Æªº¤ñ¹ïCÄæ¬O§_¬°¯S©w­È¡A¦p°²³]¨âµ§¤@¼Ë¡A´N¤ñ¹ïcÄæ¡AÀu¥ý«O¯d¦r¦ê(µ²§ô)¡A¨ä¾l§R±¼¡C
E1:¤é´Á¡A»Ý¨ú·sªº¦pCÄæ¤ñ¹ï­È¤@¼Ë³£¬Oµ²§ô¡A¦A¤ñ¹ï¤é´Á¡A¦p¤é´Á¸û´N§R°£¡A¯d·sªº¤é´Á¡A¦p¤T­ÓÄæ¦ì³£¤@¼Ë´N§R°£±Æ¦b¤W¤èªº¡C
F1 G1 H1:·s¼Wµù°O¥[¤W¤ÀªR¥Îªº¸ê®Æ¡C§R°£±¼ªº¨º¦æ¦pªGFGH¦³¸ê®Æ»Ý¶K¨ì­«½Æªº¥B«O¯dªº¨º¦æFGH¦ì¸m¡C

¤£ª¾¹D³oºØ§@·~¥i¥H¥Îvba¤@¦¸¾ã²z§¹¦¨¶Ü¡H
©Î¬O¯u§Æ±æ½Æ»s¶K¤W®É·s¸ê®Æ¯à(¦Û°Ê)»\¹LªºAÄæ¦ì¬Û¦P¸ê®ÆªºÄæ¦ì¡A¦pªG¨S¦³­«½Æªº¤~¶K¨ì¤U¤è¡C
¦p¦³±Ô­z¤£²M½Ð¤£§[§iª¾¡A«D±`·PÁ¾\Ū§¹§Úªº»Ý¨D¡C

·j´M¬ÛÃöTagsªº¤å³¹¡G [ ­«½Æ¡A±ø¥ó¡A§R°£ ] ,
¥»½g¤å³¹µoªí©ó2019-03-23 08:30
§O§Ñ®½VP·PÁÂÀ°§U§Aªº¤H ·s¤â·|­ûÁ@¤@Á@
1¼Ó
¦^À³

roar
ÀËÁ|¦¹¦^À³
ÀÉ®×¥i¥HpostÅý¤j®a¤@°_·Q¿ìªk¡C
¥»½g¤å³¹¦^ÂЩó2019-04-03 13:58
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
2¼Ó
§@ªÌ¦^À³

ypyp1015
ÀËÁ|¦¹¦^À³
¤j¤j­Ì¤£¦n·N«ä¡A½×¾Âªº¹Ï¤ùªÅ¶¡¤@ª½¶Ç¤£¤W¥h...
¥ÎGOOGLEªº¸Õ¸Õ~ÁٽФj¤j­ÌÀ°À°¦£~¤U¹Ï¥i¯à·|¦³¤@ÂIÂI¸ò¤W¤å¤£¤@¼Ë¡A½Ð¥H¦¹¬°¥D¡AÁÂÁ±z





ExcelÀÉ®×
¥»½g¤å³¹¦^ÂЩó2019-04-13 11:44
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
3¼Ó
§@ªÌ¦^À³

ypyp1015
ÀËÁ|¦¹¦^À³
¤£¦n·N«ä...¹Ï¤ù¦n¹³¤£¦æ¥u¯à¥ÎÀɮצ¡ªº... ¤]¥i°Ñ¾\ExcelÀɮײĤG­Ó¤u§@ªí

¹Ï1

¹Ï2
¥»½g¤å³¹¦^ÂЩó2019-04-13 11:48
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
4¼Ó
¦^À³

roar
ÀËÁ|¦¹¦^À³
§A¬O»¡­ì©l¸ê®Æ¥[¤W¤J¸ê®Æ«á§@¦¨¤@±iªí¡AA,C column¤@¼Ëªº¦A§PÂ_®É¶¡¡A«O¯d¸û·sªº§R°£Âªº¡A¦ý«O¯dªºµù°O¶Ü
¦pªG¦p¦¹¡A4275403174¥i¥H§R¤W­±ªº¶Ü¡A§Y­ì©l¸ê®Æªº¡A±ø¥ó¤@¼Ë®É¡A§Rªº¡A¤£µMLOGIC ¤£ª¾­n¦p¦ó¼g¡C
¥»½g¤å³¹¦^ÂЩó2019-04-13 15:19
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
5¼Ó
§@ªÌ¦^À³

ypyp1015
ÀËÁ|¦¹¦^À³
¤j¤j¹ïªº¡A
²Ä¤@ÂI«O¯dªºµù°O(§t¨ç¼Æ)¡C
¸ê®Æ³£¤@¼Ë®É¨ä¹ê¦pªG¯à«O¯dµù°O¡K§R­þ¤@­Ó³£¥i¥Hªº¡C
·PÁ¤j¤j¡C
¥»½g¤å³¹¦^ÂЩó2019-04-14 00:26
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
6¼Ó
¦^À³

roar
ÀËÁ|¦¹¦^À³
¢ç
https://drive.google.com/open?id=1p6Gg60rz8TT_tC3bahnQ1uqobLcH5Axv
¥»½g¤å³¹¦^ÂЩó2019-04-14 20:05
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
7¼Ó
¦^À³

roar
ÀËÁ|¦¹¦^À³
¸Õ¸Õ¬Ý¤W­±ªººô§}¡A§@ªk¬°¥[¤J3­ÓSHEETS,¨ä¤@¬°­ì©l¸ê®Æ¡A¥t¤@¬°¶×¤J¸ê®Æ¡A³Ì«á¬°§A­nªº¸ê®Æ¡A¤À2¶¥¬q°õ¦æ¡A²Ä¤@COPY¶×¤J¸ê®Æ¦Ü§A­nªº¸ê®Æ¡A²Ä¤G°õ¦æ¸ê®Æ¤ñ¹ï¡A¯d¤U§A­nªº¡C
¥»½g¤å³¹¦^ÂЩó2019-04-14 20:09
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
8¼Ó
§@ªÌ¦^À³

ypyp1015
ÀËÁ|¦¹¦^À³
·PÁÂroar¤j¤j¡A¤j­P¤W¦³¹F¨ì»Ý¨D¡A¦ý...¦pªG­ì©l¸ê®Æ¤£¤@©w·|¦b¶×¤J¸ê®Æ¤§¤ºªº¸Ü¬O§_¿ìªº¨ì©O?

­ì¥Øªº¬O´Á±æ¨C¤é¶×¤J¸ê®Æ°µ¾ã²z¡A¸ê®Æ¨Ó·½¥Ñ¨t²Î¶×¥X¥i¨ú±oªº¸ê®Æ·|¸ò§Ú­ì©l¸ê®Æ¦³­«½Æ¬G»Ý­n°µ¿z¿ï(¨t²Î¬O¥H¤é´Á°µ¶×¥X)¡A¦]¦¹¤é´Á¹L¤[§Úªº­ì©l¸ê®Æ´N¤£¦b¶×¤J¸ê®Æ¤º¤F¡A
¥B¦¹­ì©l¸ê®Æ¼Æ¾Ú²Ö­p¤U¨Ó¥i¯à·|¦³¤W¦æ...¶×¤J¸ê®Æ¥i¯à´X¦Ê¥ó¡C

·PÁ¤j¤j¦b©âªÅÀ°À°¦£~ÁÂÁ¡Aªþ¤W§Ú¹ê»Ú¸ê®ÆÀɮװѦÒ
Excel¹ê»Ú¹B§@­ì©l¸ê®Æ&¶×¤J¸ê®Æ
¥»½g¤å³¹¦^ÂЩó2019-04-15 02:27
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
9¼Ó
¦^À³

roar
ÀËÁ|¦¹¦^À³
¤Ó¦h¤F¡A§A¨Ì¥Ø«eªº¸ê®Æªí¾ã²z¤@¤U¡A2­Ósheet¦U¬ù10µ§¥]§t¦UºØ±¡§Î¡A§Ú¦A¸Õ¸Õ¡A¤£µM§Ú·|²´ªá¡C
¥»½g¤å³¹¦^ÂЩó2019-04-15 13:37
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
10¼Ó
§@ªÌ¦^À³

ypyp1015
ÀËÁ|¦¹¦^À³
roar¤j¤j¤£¦n·N«ä¡A§Ú¤w¸g­«·s¤W¶Ç¤F~~
½Ð±z¦A¬Ý¬Ý¤@¤UexcrlÀɮסA«D±`·PÁ±z¡C
³]­p«áªº¸ê®ÆÀÉ
¥»½g¤å³¹¦^ÂЩó2019-04-17 01:44
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
11¼Ó
¦^À³

roar
ÀËÁ|¦¹¦^À³
https://drive.google.com/open?id=1p6Gg60rz8TT_tC3bahnQ1uqobLcH5Axv
¥»½g¤å³¹¦^ÂЩó2019-04-19 10:25
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
12¼Ó
§@ªÌ¦^À³

ypyp1015
ÀËÁ|¦¹¦^À³
roar¤j¤j±z¦n¡A«D±`·PÁ±z¡A¸g´ú¸Õ´X¥G¬O¹F¨ì¤F§Úªº·Q¹³~¶W¼F®`~

¥Ø«e¨Ï¥Î¤¤µo²{¨ìStatusReplace³o¬q¶È½Æ»s¤F¤ñ¹ïªº¬ÛÃöÀx¦s®æ¡A¦Ó§Ú´Á±æ¬O±N¾ã¦æ±q¶×¤J¸ê®Æ¤u§@ªícopy¥X¨Óe.x. D~FFÄæ¦ì³£copy¡C
¦Û¤v¹Á¸Õ¤F§ó§ï...¦ü¥GµL®Ä¡A¤£ª¾¹D¬O§_¦³¸û²©ö¤è¦¡~~§_»Ý¤@µ§¤@µ§KEY¤J~

ThisWorkbook.Worksheets("°õ¦æVBA«áªº­ì©l¸ê®ÆÀÉ").Range("D" & relocate).Value = ThisWorkbook.Worksheets("¶×¤J¸ê®Æ").Range("N" & i).Value
....
ThisWorkbook.Worksheets("°õ¦æVBA«áªº­ì©l¸ê®ÆÀÉ").Range("FF" & relocate).Value = ThisWorkbook.Worksheets("¶×¤J¸ê®Æ").Range("AL" & i).Value

¹Á¸Õ§Ûŧ¤W¬qªº¥N½X¬OµL®ÄªºXD
ThisWorkbook.Worksheets("¶×¤J¸ê®Æ").Range("D" & i & ":" & "FF" & i).Copy ThisWorkbook.Worksheets("°õ¦æVBA«áªº­ì©l¸ê®ÆÀÉ").Range("D" & j & ":" & "FF" & j)
¥»½g¤å³¹¦^ÂЩó2019-04-22 02:25
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
13¼Ó
¦^À³

roar
ÀËÁ|¦¹¦^À³
¥i¯à¬O³o¼Ë¡A¦]´ú¸ÕªºùØ­±¦n¹³¨S¦³D~M¤ÎAN~FF¸ê®Æ¡A©Ò¥H¨S¦³¹ê´úµ²ªG¡A¦pªG¦³°ÝÃD¦A¥[¤W¸ê®Æ§Ú¸Õ¸Õ¬Ý¡C¥H¤Ucode©ñ¦b--°õ¦æVBA«áªº­ì©l¸ê®ÆÀɤu§@ªí¤º

¥»½g¤å³¹¦^ÂЩó2019-04-24 10:05
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
14¼Ó
§@ªÌ¦^À³

ypyp1015
ÀËÁ|¦¹¦^À³
¤j¤j±z¦n¡A¸g¹Á¸Õ¨Ï¥Î¡A¤W¤åµ{¦¡½X¤¤·s¼Wªº²Ä42¡B43¦æ¡A¸ò41¦æ¤@¼Ë¬O±N­ì©l¸ê®Æªº¬ÛÃö¦æ¼Æ¸ê®Æ°µ«O¯d(ÂÂ¸ê®Æ)¡C

¦ý»Ý¨Dªº¬O»Ý­n¤ñ¹ï«á¤£¦Pªº¸ê®Æ¥Ñ¶×¤J¸ê®Æ¶×¾ã¨ì­ìªí®æ¡A¤]´N¬O¤W¤åµ{¦¡½X¤¤63¡B64¡B65¦æ¡A¶È¦]¬°¦¹¤T¦æ¥ucopy¤F¤T­ÓÄæ¦ì¡A§Ú·Q­n±ND~MMÄæ¦ì³£¤@¨Ö»\¹L¡AÁöµM¥i¥H¤@¦æ¤@¦æªº½Æ»s§ó§ï...¦ý·Q¸ß°Ý¬O§_¦³¸û²©öµ{¦¡½X¤@¤f®ð§ó§ï§¹¦¨~

ÁÂÁ¡C
¥»½g¤å³¹¦^ÂЩó2019-04-27 13:34
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
15¼Ó
³Ì¦³»ù­È¸Ñµª

roar
ÀËÁ|¦¹¦^À³
°Ñ¦Ò¬Ý¬Ý§a
https://drive.google.com/open?id=1p6Gg60rz8TT_tC3bahnQ1uqobLcH5Axv
¥»½g¤å³¹¦^ÂЩó2019-04-27 18:36
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
   
1

¦^ÂÐ
¦p­n¦^À³,½Ð¥ýµn¤J.