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

[µo°Ý] ³sµ²¸ê®Æ®w °ÝÃD

[µo°Ý] ³sµ²¸ê®Æ®w °ÝÃD

¥»©«³Ì«á¥Ñ jackyliu ©ó 2011-2-27 07:07 ½s¿è

1. ½Ð±Ð¤@¤U ³sµ²¸ê®Æ®w¥H¤U»yªk ,­þ¸Ì¥X¤F°ÝÃD¥i§_À°¦£.
(¼´¨úABC¸ê®Æ®w ®É¶¡¤j©óµ¥©ó¤µ¤Ñ¤é´Á, ¦p: 2011-02-27 )

.CommandText = Array(
"SELECT  * " & Chr(13) & "" & Chr(10) & _
         "FROM ABC " & Chr(13) & "" & Chr(10) & _
         "WHERE  START_TIME>=NOW()")

2. ¼´¨ú¸ê®Æ®w§¹«á, excel ¦Û°Ê¥t¦s·sÀÉ ©M excel Ãö³¬; ­n¦p¦ó°µ.

3.     .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .PreserveColumnInfo = True
        .Refresh BackgroundQuery:=False
¥H¤W³o¨Ç µ{¦¡code ³£¤@©w­n¶Ü? §Ú¬O¥Î¥¨¶° ¿ý»s «á²£¥Í¥X¨Óªº.... ¤£ª¾¹D¥i¥Hºë²¶Ü?

¥»©«³Ì«á¥Ñ carzyindex ©ó 2011-3-1 14:31 ½s¿è

¦^´_ 1# jackyliu
    ²Ä¤GÂI
          ActiveWorkbook.SaveCopyAs Filename:="C:\Documents and Settings\user\®à­±\123.xlsx"

    ²Ä¤TÂI  excel¬d¸ß¤@¤U´Nª¾¹D­þ¨Ç»Ý­n³]©w­þ¨Ç¤£¥Î

TOP

¼Ó¤W  ¦P¾Ç ¨S¦³À°¦£¨ì §Úªº°ÝÃD, ¤£¹L ¤]«Ü·P¿E±z...
¨ä¹ê §Ú¦³¸Õ¤F¦n¤[ ...¤~´£°Ýªº

·Q­n ¦bDB ¼´¨ú ¤j©óµ¥©ó¤µ¤Ñ¤é´Á ªº¸ê®Æ, ¨Ã¥Bª½±µ¥t¦s·sÀÉ,
ÁÙ¦³²Ä¤T¶µ ¸Ìªºµ{¦¡ ­Y®³±¼ ·|µLªk°õ¦æµ{¦¡, ©Ò¥H ·Q°Ý¬°¤°»ò?
¬O§_¥i§ï?

TOP

¼Ó¤W  ¦P¾Ç ¨S¦³À°¦£¨ì §Úªº°ÝÃD, ¤£¹L ¤]«Ü·P¿E±z...
¨ä¹ê §Ú¦³¸Õ¤F¦n¤[ ...¤~´£°Ýªº

·Q­n ¦bDB ¼´¨ú  ...
jackyliu µoªí©ó 2011-3-2 20:52



    ¥i¥Hµo¤@¤UÀɤW¨Ó¸Õ¸Õ¶Ü?
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¨S¦³¿ìªk ±N¾ã­Ó¸ê®Æ®w ¶Ç¤W¨Ó...
©Ò¥H  ¬O·Q¤F¸Ñ §Úªºµ{¦¡code °ÝÃD ,
¦bDB ¼´¨ú ¤j©óµ¥©ó¤µ¤Ñ¤é´Á ªº¸ê®Æ, ¨Ã¥Bª½±µ¥t¦s·sÀÉ,
ÁÙ¦³²Ä¤T¶µ ¸Ìªºµ{¦¡ ­Y®³±¼ ·|µLªk°õ¦æµ{¦¡, ©Ò¥H ·Q°Ý¬°¤°»ò?
¬O§_¥i§ï?

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD