I have a PowerPoint presentation w/ an embedded Excel Workbook, name: ThisWorkbook I need to export ThisWorkbook into an Excel File.
我有一个带有嵌入式Excel工作簿的PowerPoint演示文稿,名称:ThisWorkbook我需要将ThisWorkbook导出到Excel文件中。
Thank you
1 个解决方案
#1
Are you sure the worksheet is called "ThisWorkbook"? ThisWorkbook is the reference that is used to refer to the workbook in which the code module resides. On inserting a worksheet it will be named "Worksheet in Presentation1", or similar.
你确定工作表叫做“ThisWorkbook”吗? ThisWorkbook是用于引用代码模块所在的工作簿的引用。在插入工作表时,它将被命名为“Presentation1中的工作表”或类似名称。
To save the file you can use the following in an Excel code module (Alt+F11 when the worksheet is active)
要保存文件,您可以在Excel代码模块中使用以下内容(工作表处于活动状态时Alt + F11)
ThisWorkbook.SaveAs Filename:="mypath\myfilename.xls"
#1
Are you sure the worksheet is called "ThisWorkbook"? ThisWorkbook is the reference that is used to refer to the workbook in which the code module resides. On inserting a worksheet it will be named "Worksheet in Presentation1", or similar.
你确定工作表叫做“ThisWorkbook”吗? ThisWorkbook是用于引用代码模块所在的工作簿的引用。在插入工作表时,它将被命名为“Presentation1中的工作表”或类似名称。
To save the file you can use the following in an Excel code module (Alt+F11 when the worksheet is active)
要保存文件,您可以在Excel代码模块中使用以下内容(工作表处于活动状态时Alt + F11)
ThisWorkbook.SaveAs Filename:="mypath\myfilename.xls"