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

[µo°Ý] ¦³Ãösheet¦WºÙªº°ÝÃD

With Workbooks.Open("a.xls")  '¶}±ÒÀÉ®×
      with .sheets(format(date,"mmdd")) '¶}±ÒÀɮפºªº¤é´Á¤u§@ªí
      end with
end with
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# imzues


    With Workbooks.Open("a.xls")  '¶}±ÒÀÉ®×
      with .sheets(format(date,"mmdd"))'¶}±ÒÀɮפºªº¤é´Á¤u§@ªí
           with .Range("a:a") '¤u§@ªí¤ºªºAÄæ

                end with
      end with
end with

³o¬Oª«¥ó¶¥¼hªº·§©À°ÝÃD
WORKBOOKS¤º¥]§tWORKSHEETS
WORKSHEETS¤º¥]§tRANGE
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Resize(, .Count) ³o·|¬O¦h¤j½d³ò©O?
³o¥i¬O¥u¦³¤@¦C100Äæ­ò
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD