vba 将包含宏的工作簿复制到没有宏的工作簿
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14583914/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Copy workbook containing macro to a workbook without macro
提问by Kaushik Datye
I am able to duplicate a workbook (copy to a desired location) which contains a macro in the background. This duplicate copy also contains the same macro. My Problem is I do not want this duplicate workbook to have a macro with it. Can anyone tell how to do it?
我能够复制一个在后台包含宏的工作簿（复制到所需位置）。这个重复的副本也包含相同的宏。我的问题是我不希望这个重复的工作簿有一个宏。谁能告诉怎么做？
Thank you in advance!!!
先感谢您！！！
回答by Peter L.
Save your workbook as macro-free, i.e. simply as Excel Workbook. For my Excel 2007 this is done using:
将您的工作簿另存为无宏，即简单地保存为 Excel 工作簿。对于我的 Excel 2007，这是使用以下方法完成的：
Application.DisplayAlerts = False
ThisWorkbook.CheckCompatibility = False
ThisWorkbook.SaveAs Filename:="D:\DOCUMENTS\Book1.xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Application.DisplayAlerts = True
Correct path & name as you wish.
根据需要更正路径和名称。
Read more about SaveAsmethod: http://msdn.microsoft.com/en-us/library/office/ff841185%28v=office.14%29.aspx...and available File Formats: http://msdn.microsoft.com/en-us/library/office/ff198017%28v=office.14%29.aspx
阅读有关SaveAs方法的更多信息：http: //msdn.microsoft.com/en-us/library/office/ff841185%28v=office.14%29.aspx...和可用的文件格式：http: //msdn.microsoft。 com/en-us/library/office/ff198017%28v=office.14%29.aspx
Hope that was helpful)
希望有帮助）
