[µo°Ý] (¤w¸Ñ¨M)¤u§@ªí¦WºÙªº¤è¦¡

freeffly

§Ú·Q°Ý¤@¤U¦pªG§Ú·QÅývba¥N¤é´Áªñ¥h¤u§@ªí¦WºÙ­n¦p¦ó³]
¦p0321¸ê®Æ  0322¸ê®Æ
¸ê®Æ¦W¤£°Ê¥i¬O«e­±ªº¤é´Á·|¨Ì·í¤Ñ¥h§ï

GBKEE

¦^´_ 1# freeffly
Sheet1.Name = Format(Date, "mmdd")

freeffly

¦^´_ 2# GBKEE


    µª®×¦n¹³§Ö¥X¨Ó¤F
     «á­±¦pªG­n¦A¥[¨ä¥L¦r²´
    ¦p"¸ê®Æ"©Î¬O"Á`ªí" ­n¥Î¤°»ò¤è¦¡?

freeffly

¦^´_ 2# GBKEE


    ¸Õ¥X¨Ó¤F
      ÁÂÁ³á

freeffly

¦^´_ 2# GBKEE

   ÁÙ¦³¤@­Ó°ÝÃD
  ¤@¯ë§Ú¦pªG¼W¥[¥H¤äªº¤u§@ªí¦WºÙ
   ¦p¤U­±
   sheets.add.name="0322¸ê®Æ"
    ´N¥i¥Hª½±µ¿ï¨ú
   sheets("0322¸ê®Æ")
   ¨º¤U­±³o¦U¤è¦¡­n«ç»ò¿ï¨ú?

    Sheet1.Name = Format(Date, "mmdd")&"¸ê®Æ"
   ¥Î³oºØ¤è¬O·s¼W¤u§@ªí¤£¥u¤@­Ó
  ½Ð°Ý¦³¤°»ò¤è¦¡¶Ü

GBKEE

¦^´_ 5# freeffly
Sheet1.Name = Format(Date, "mmdd")&"¸ê®Æ"   ¬O«ü©w¤u§@ªí¦WºÙ
­n·s¼W¤u§@ªí¦p¤U

1. Sub Ex()
   
2.     With Sheets.Add   '·s¼W¤u§@ªí
   
3.         .Name = Format(Date, "mmdd") & "¸ê®Æ"
   
4.     End With
   
5. End Sub

½Æ»s¥N½X

freeffly

¦^´_ 6# GBKEE


    §Úªº·N«ä¬O¹ï¸Ó·s¼Wªº¤u§@ªí§@·~
    ¤j¤jªº·N«ä¬O­n±N§@·~ªºµ{¦¡½X§Ë¨ìwith¸Ì­±¶Ü

GBKEE

¦^´_ 7# freeffly
sheets.add.name="0322¸ê®Æ"   »yªk¿ù»~
¥Î WITH  ¬O«K©ó³B¸Ì  WITH ª«¥óªºÄÝ©Ê, ¤èªk.
Sub Ex()
    With Sheets.Add
        .Name = "0322¸ê®Æ"
        .Range("A1:C1") = Array(1, 2, 3)
        .Range("A1:C1").Select
     End With
End Sub
¦P¤W
Sub Ex()
    Sheets.Add
    ActiveSheet.Name = "0322¸ê®Æ"
    ActiveSheet.Range("A1:C1") = Array(1, 2, 3)
    ActiveSheet.Range("A1:C1").Select
End Sub

freeffly

¦^´_ 8# GBKEE


    ¤F¸Ñ
   ÁÂÁÂ

diabo

sheets.add.name="0322¸ê®Æ"

³oµ{¦¡½X¬O³Ìµuªº¡u·s¼W¤u§@ªí¨Ã©R¦W¡v¡A°ß¶·¥ýÀˬd¡u0322¸ê®Æ¡v¤u§@ªí¬O§_¦s¦b

»yªk¦³µL¿ù»~¡A§Ú¤£ª¾¹D¡A¦ý¤@ª½¥H¨Ó³£³o¼Ë¥Î...