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

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

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

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:05 ½s¿è

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

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

TOP

¦^´_ 2# GBKEE


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

TOP

¦^´_ 2# GBKEE


    ¸Õ¥X¨Ó¤F
      ÁÂÁ³á
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 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¤@­Ó
  ½Ð°Ý¦³¤°»ò¤è¦¡¶Ü
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 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

TOP

¦^´_ 6# GBKEE


    §Úªº·N«ä¬O¹ï¸Ó·s¼Wªº¤u§@ªí§@·~
    ¤j¤jªº·N«ä¬O­n±N§@·~ªºµ{¦¡½X§Ë¨ìwith¸Ì­±¶Ü
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 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

TOP

¦^´_ 8# GBKEE


    ¤F¸Ñ
   ÁÂÁÂ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

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¼Ë¥Î...
diabo

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD