- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# if208808 - Option Explicit
- Sub Ex() 'SaveCopyAs ±N«ü©w¬¡¶Ã¯ªº³Æ¥÷Àx¦s¨ìÀɮסA¦ý¤£Åܧó°O¾ÐÅ餤¤w¶}±Òªº¬¡¶Ã¯¡C
- Dim F As String, M As String
- F = "D:\Test.xls"
- M = "¥t¦s·sÀÉ"
- If Dir(F) <> "" Then M = F & " Àɮפw¦s!!! , ¦b§_n¨ú¥N¥¦?"
- If MsgBox(M, vbYesNo) = vbYes Then Me.SaveCopyAs F
- End Sub
- Sub Ex1() 'SaveAs ±N¹ï¬¡¶Ã¯ªºÅܧóÀx¦s¨ì¨ä¥LÀɮסC
- 'SaveAs ¨S¦³¬Û¦PÀɦW,¨t²Î¤£·|¸ß°Ý.
- 'Application.DisplayAlerts = True '¨t²Î¹w³]¬° True ¤]¥iµù¸Ñ¤£¥Îªº
- '¦p°õ¦æ¥¨¶°®É Microsoft Excel Åã¥Ü¯S©wªºÄµ§i©M°T®§«h¬° True
- On Error Resume Next
- Me.SaveAs "D:\Test.xls"
- End Sub
½Æ»s¥N½X |
|