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

[µo°Ý] ½Ð°Ýexcel¦sÀɮɡA¦p¦ó¯à°÷¤£­nÅã¥ÜÀɮפw¸g¦s¦b°T®§¡Aª½±µÂл\¡H

[µo°Ý] ½Ð°Ýexcel¦sÀɮɡA¦p¦ó¯à°÷¤£­nÅã¥ÜÀɮפw¸g¦s¦b°T®§¡Aª½±µÂл\¡H

½Ð°Ýexcel¦sÀɮɡA¦p¦ó¯à°÷¤£­nÅã¥ÜÀɮפw¸g¦s¦b°T®§¡Aª½±µÂл\ÀɮסH

³Â·Ð¤j®a°Õ¡ã
ÂżÝ

Sub test()
   Workbooks("123.xls").Close SaveChanges:=True '¦Û°ÊÀx¦sÃö³¬
End Sub

Sub test1()
   Workbooks("123.xls").Save '¦Û°ÊÀx¦s¤£Ãö³¬
End Sub

TOP

¥t¦sÀɮתº¸Ü
  1.     Application.DisplayAlerts = False
  2.     ActiveWorkbook.SaveAs Filename:="¦ì¸m"
  3.     Application.DisplayAlerts = True
½Æ»s¥N½X
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

ÁÂÁ¤j®aÀ°¦£¡A°ÝÃD¤w¸g¸Ñ¨M     Thanks¡I
ÂżÝ

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD