将包含宏的工作簿复制到不包含宏的工作簿中 [英] Copy workbook containing macro to a workbook without macro

问题描述

我能够复制一个工作簿(复制到所需的位置)，该工作簿在后台包含一个宏.此重复的副本还包含相同的宏. 我的问题是我不希望这个重复的工作簿带有宏.谁能告诉我怎么做?

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?

预先感谢您！

推荐答案

将工作簿保存为无宏，即简单保存为Excel工作簿.对于我的Excel 2007，使用以下方法完成:

Save your workbook as macro-free, i.e. simply as Excel Workbook. For my Excel 2007 this is done using:

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.

了解有关SaveAs方法的更多信息: http ://msdn.microsoft.com/zh-CN/library/office/ff198017%28v=office.14%29.aspx

Read more about SaveAs method: 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

希望对您有帮助)

这篇关于将包含宏的工作簿复制到不包含宏的工作簿中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！