Have Geek Brain

Export an embedded Excel workbook to a PowerPoint slide in Excel

I have a PowerPoint presentation with an embedded Excel workbook, title: ThisWorkbook

I need to export ThisWorkbook

to Excel file.

thanks

0


a source to share


1 answer


Are you sure the worksheet is called "ThisWorkbook"? ThisWorkbook

is the link used to refer to the book that contains the code module. When you insert a sheet, it will be named "Worksheet in Presentation1" or similar.

To save the file you can use the following in the Excel Code Module (Alt + F11 when the worksheet is active)



ThisWorkbook.SaveAs Filename:="mypath\myfilename.xls"
0


a source






More articles:


All Articles