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

[µo°Ý] ®Ú¾Ú"®Æ¸¹Äæ"¬°¨Ì¾Ú,°µ±Æ§Ç

¦^´_ 39# °a¤ªºµ

ºµ¤j,
ÁöµM§Ú´«¤F¤@­Óªí®æ,»Ý¶ñ¤J¤u§@ªíªº®æ¤l´«¤F¦ì¸m¦Ó¤w,¨ä¾lªº¨Ã¨S¦³ÅÜ°Ê,
¦pªG±z»{¬°¨ä¥Lªº°ÝÃD»Ý­n¤j¶q§ïµ{¦¡,´N¤£­n³Â·Ð¤F¡I
¥u¬O·Qª¾¹D...
Àx¦s®æ¦ì¸m§Ú³£­×§ï¦n¤F,¬°¦ó´«¤F¤@­Ó¤u§@ªí,µ{¦¡ÀÉ´N¤£¯à¹B§@?

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-4-26 23:59 ½s¿è

¦^´_ 41# PJChen
¦]¬° ©pªºa1¬Oª«¥ó ¤£¬OÅÜ¼Æ ¦pªG­n«ü©w¸ôªñ ´N¤£»Ý­n¿ï¾Ü¦ì¸m ­n§ï¦¨Ãþ¦ü³o¼Ëªº¼gªk
'    A1 = Dir(ThisWorkbook.Path & "\" & "°Ó«~2.xlsm")
'    Ex.Workbooks.Open ThisWorkbook.Path & "\" & A1
¤£³Â·Ð ¦]¬°§Ú­Ì¬O¤¬¬ÛÀ°§U ^_^ §Ú¥u¬O­n½T»{©p­nªºµ²ªG¦Ó¤w
¦³ªÅ¦AÀ°§Ú¸Õ¸Õ¬Ý ¬O¤£¬O©p­nªºµ²ªG ·PÁÂ

Micro_20426.rar (38.84 KB)

TOP

¦^´_ 42# °a¤ªºµ

ºµ¤j,
§Ú¨S¦³­n«ü©w¸ô®|,¸ô®|¥u¬O¦Û¤v°Ñ¦Ò¥Îªº,³£»¡¤F­n­ì¼gªk,
¥u¬O§ïÅÜ3­Ó¿é¤JÀx¦s®æ¦ì¸m...¦Ó¥B³£­×§ï¦n¤F,¬°¦ó´«¤F¤@­Ó¤u§@ªí,µ{¦¡ÀÉ´N¤£¯à¹B§@?
¦Ó¥B§Ú¨S¦³³]©wa1,±z»¡ªºa1¬Oª«¥ó ¤£¬OÅÜ¼Æ ?¤£²z¸Ñ,§Ú¦³©ñ¤°»òª«¥ó?

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2021-4-27 00:20 ½s¿è

¦^´_ 43# PJChen
³o¬q©p¬Ý¤@¤U ³o¬O«ü©w¸q¬° ¬¡­¶Ã¯ ª«¥ó
Dim a1 As Workbook, xS As Worksheet, Sh As Worksheet, wO$, Arr, xD

TOP

¦^´_ 44# °a¤ªºµ

¦]¬°¦b°õ¦æµ{¦¡¹Lµ{¤¤,°õ¦æ¤@¦¸´N¥X²{¤@­Ó¹ï¸Ü®Ø,«Ü¦h¡B«Ü¦h¦¸,©Ò¥H´N¤@ª½Dim....
³o¦¸ªºµ{¦¡³Ìªñ§Ú·Q­nªº,·PÁ±z....

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD