将PowerPoint幻灯片中的嵌入式Excel工作簿导出到Excel

时间:2022-09-28 13:07:18

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"