Home Filling existing powerpoint tables with Excel data using VBA
Reply: 0

Filling existing powerpoint tables with Excel data using VBA

Vincent
1#
Vincent Published in 2018-02-14 15:31:00Z

I'm trying to fill tables of an existing powerpoint presentation with data from an Excel worksheet.

So the data from AB5:AD14 should be copied in an existing table on on slide 1. The table has 11 rows and 9 columns and the cells should be pasted using row 2, column 3 as top left cell.

After this has been done the data from AB15:AD24 should be copied to slide 2 to a table with the same format.

This then goes on for 15 slides.

Is there a way using VBA to make this work? I'm fairly new to VBA, so all help is very appreciated!! :)

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.316488 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO