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

[µo°Ý] ªíÀY©M­¶©³ªº¤å¦r³¡¤ÀªºÄݩʦ³¥i¯à³Q§ó§ï¶Ü?

[µo°Ý] ªíÀY©M­¶©³ªº¤å¦r³¡¤ÀªºÄݩʦ³¥i¯à³Q§ó§ï¶Ü?

µ{¦¡¤ù¬q¦p¤U:

With ActiveSheet.PageSetup
        .LeftHeader = "­Ü®w¥X³f°O¿ýªí"
        .RightHeader = "µ{¦¡²Ä0001¸¹"
        .RightFooter = "²Ä &P ­¶¡A¦@ &N ­¶"
End With


¦p¤W,¦b³øªí¦C¦L¤¤, "­Ü®w¥X³f°O¿ýªí" ³o¨Ç¦r¦êªºÄÝ©Ê¥i¯à³Q§ïÅܶÜ?
¦p§ï¦¨ ¶ÂÅé ¼Ð·¢Åé  §ï¦¨ ²Ä 18 ¸¹ ¦rµ¥ ...
V98

¦^´_ 1# linshin1999
¬O²ÊÅ餣¬O¶ÂÅé.
¥Î¿ý»s·s¥¨¶°¥i±o.
With ActiveSheet.PageSetup
        .LeftHeader = "&""¼Ð·¢Åé,²ÊÅé""&18­Ü®w¥X³f°O¿ýªí"
        .RightHeader = "&""¼Ð·¢Åé,²ÊÅé""&18µ{¦¡²Ä0001¸¹"
        .RightFooter = "&""¼Ð·¢Åé,²ÊÅé""&18²Ä P ­¶¡A¦@ &N ­¶"
End With

TOP

¦^´_ 2# GBKEE


    GBKEEª©¥D ÁÂÁ§A,ªoº£´N¬O­n¨ê¤l,§ä¤£¨ì¨ê¤lªº®É­ÔÁÙ¯u³Â·Ð,¦³§A­Ì§Ú­Ì¥i¥H¸`¬Ù«Ü¦h§ä¨ê¤lªº®É¶¡,ÁÂÁ¤F!!
V98

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD