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

[µo°Ý] ¦C¦L¦Û°Ê½s¬y¤ô¸¹°ÝÃD

[µo°Ý] ¦C¦L¦Û°Ê½s¬y¤ô¸¹°ÝÃD

¤£¦n·N«ä¡A§Ú¤S¦³°ÝÃD¤F
½Ð±Ð¤@¤U¦U¦ì¤j¤j
¦b¨Ï¥ÎExcel¦C¦L®É¡A¥i¥H¨Ì¦C¦Lªº¥÷¼Æ°µ¬y¤ô¸¹¶Ü¡H
¨Ò¦pExcel¥u¦³¤@­Ó­¶­±¡A§Ú¦b¦C¦L³]©w®É¦C¦L¢´¥÷
¡@¡@¥i¥H¥Î¤°»ò¤è¦¡¦b¢´¥÷¬Û¦P¸ê®Æ¤WÅã¥Ü1~5¶Ü?
¥H¤W¡AÁÂÁÂ
Simon

¦^´_ 1# simon.chenpro

¥i¥H¥ý°Ñ¦Ò¦¹½g
    http://forum.twbts.com/thread-1266-1-2.html
¦A±N±zªº»Ý¨DªþÀɤW¶Ç..¥ý¶i¤Îª©¥D¤~¯à²M·¡²z¸Ñ±zªº»Ý¨D..¥[³t±zªº°ÝÃD¸Ñ¨M¤è¦V
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¦^´_ 1# simon.chenpro


    ³o¬O¨t²Îªº³¡¥÷¤å³¹±z¤]¥i¥H°Ñ¦Ò¬Ý¬Ý

http://gb.twbts.com/index.php?topic=2336.0

http://gb.twbts.com/index.php?topic=7060.0

http://gb.twbts.com/index.php?topic=6018.0
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

ÁÂÁÂPD961A¤j¤jªº¦^ÂÐ
¤£¹L§Ú­nªºµª®×¤£¬O³o­Ó
¨S¦³ªþÀÉ¡A´«¥t¤@ºØ»¡©ú¤@¤U
¨Ò¦pA1Äæ¦ì³]©w¬°"n/m"¡A¦C¦L®É§Ú³]©w¦C¦L¢´¥÷
¨ä¢´¥÷¤À§O¦C¦L®ÄªG¬°"1/5"  "2/5"  "3/5"  "4/5"  "5/5"
¥H¤W¡AÁÂÁÂ~~
Simon

TOP

¦^´_ 4# simon.chenpro


    ª½±µ³]©w­¶­º/­¶§À??

2.gif


¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¤£¦n·N«ä¡AÁÙ¬O¤£¹ï
§Aªº¤è¦¡¬O¦C¦L5­¶ªº®ÄªG
§Ú«üªº¬O¦C¦L¢´¥÷ªº®ÄªG
Simon

TOP

¦^´_ 6# simon.chenpro


    ^ ^...¤£¦n·N«ä...
¨ä¹ê¦pªG¥÷¼Æ¥u¦³5¥÷...¨º±z´N¤â¤u¤@¤U...A1Àx¦s®æ1/5~5/5Åo...µM«á³]©w¦C¦L½d³ò
­Y¬O500¥÷´N....¥[ªoÅo....  ^ ^..
±zªº°ÝÃD«Ü²M·¡¤F..À³¸Ó·|¦³¼ö¤ßªº¥ý¶i¤Îª©¥DÀ°±zªº......
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

Sub Macro1()
    For i = 1 To 5
     Cells(1, 1).NumberFormatLocal = "@"
     Cells(1, 1) = i & "/5"
         ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
        Next i
  End Sub
joviwang

TOP

joviwang¤j¤j
¤£¦n·N«ä,¦]¬°§Ú¹ïVBA¤£À´
¥i¥H°µ¸Ô²Ó»¡©ú¤@¤U¶Ü?
¥xªÌ¬OGIF³Ì¦n¤F.....
ÁÂÁÂ
Simon

TOP

§Ú¬O¤p¾Ç¥Í¡A·|ªºªF¦è¤£¦h¡A¥u¯à¤gªk·Ò¿û¡C
Sub Macro1()
    For i = 1 To 5   '­n¦L500¦¸´N³]1 to 500
     Cells(1, 1).NumberFormatLocal = "@"  '¥Î¿ý»s¾Ç¨Óªº¡A³]©wA1¬°¤å¦r®æ¦¡
     Cells(1, 1) = i & "/5"                             'A1¤º®e¬°i/5¡Ai¬O1®É¡A´NÅã¥Ü1/5¡Ai¬O2®É¡A´NÅã¥Ü2/5

         ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True  '¥Î¿ý»s¾Ç¨Óªº¡A³]©w¦C¦L°Ê§@      
    Next i
  End Sub
joviwang

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD