PDA

View Full Version : Copying table from Excel, and saving error



erestel
02-02-2014, 01:32 PM
I am dealing with two problems, help to either or both would be greatly appreciated.

I have a few cells in Excel that I would like to paste as a table (i.e. not linked image, embed, etc) on a slide, then saving the slide. After various fails trying to use "Shapes", I found this to be working:

PPApp.CommandBars.ExecuteMso ("PasteSourceFormatting")

Yet I am given errors when I try to manipulate the height, width etc. of the pasted table. The macro cannot seem to find the table just pasted, even though on screen it appears to be selected.

Then I tried to save the Powerpoint using this:

PPPres.SaveAs saveName, ppSaveAsDefault

And I get
Now I get Method 'SaveAs' of object '_Presentation' failed.

My questions:
1. How can I edit the table just pasted?
2. How can I save the presentation?

Thanks!