Hi all
Could you please help me with something?
I try to export an table in Excel into Powerpoint to create an presentation easily.
The code works when I execute step by step but not when I press F5…
The problem is that I insert a new slide and then I want to paste the first table. When running it does not execute this properly (I believe that the myShape is not correctly defined…)
Thanks and Regards,
Flo
Please Login or Register to view this content.
Its a bit difficult without seeing the workbook & powerpoint.
However you add a slide - ppLayoutEmpty
then you are assigning a shape based on finding the shape on that slide.
Only thing is if its an empty slide then there are no shapes to count and therefore your code will error as its got no shape to use
try debug.print myslide.shapes.count before the line that errors and see if it returns a value
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Take a look here:
https://www.excelforum.com/excel-pro...ml#post4753988
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks