ªð¦^¦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 : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD