To paste tables in editable form to specific slides of existing PowerPoint document

Hello,

I am new to VBA and I encountered some issues. My issues are:

1. I have to paste a lot of tables to specific slides in existing PowerPoint document
2. All the tables must be editable (in default form) in the slides.
3. The tables must be positioned as not to affect the header on top of any typical presentation slides.

Hereby I attached the Excel file which contains the tables. I have also included the info on which table must be in which slide under column K.

https://drive.google.com/open?id=0B4...VFCb0Jaek40TmM

Hope you guys can help me as I have a deadline to meet. Your help is really appreciated.

Have a nice day.

Please Login or Register  to view this content.

Here is a code similar to what I want but the problem is this is for chart and it creates new PPT instead of an existing file of PPT. May anyone enlighten me?

Ell,

I should have downloaded your file prior to starting. You had used the verbiage "Tables" but your workbook does not have any tables in it. You have several groups of data with headers.

I converted the first 10 groups of data to tables and the above code worked flawlessly in your workbook.

Either convert your data to tables and use the code above or use different code to copy over a range of cells to PowerPoint slides.

Maud

Originally Posted by Maudibe

Ell,

I should have downloaded your file prior to starting. You had used the verbiage "Tables" but your workbook does not have any tables in it. You have several groups of data with headers.

I converted the first 10 groups of data to tables and the above code worked flawlessly in your workbook.

Either convert your data to tables and use the code above or use different code to copy over a range of cells to PowerPoint slides.

Maud

Hi Maud,

First of all thank you so much for your help. But I could not run the code. May I know what could be the reason?

Regards.

Ell,

For the code to work properly, please change your data sets to tables as I have tested this on your worksheet. The second option is to acquire code that will copy a range of data to PowerPoint slides instead of tables

Maud

Hi Maud,

I have changed all the tables to its actual table form but the code seems to have an error which is run-time error 424: Object required. Can I see my worksheet which you have changed to tables form? Thank you so much for your assistance.

Regards.

Hi Ell,

Attached is your original workbook with first ten or so data sets converted to tables along with the above added code. I already referenced the Microsoft PowerPoint Library which is something you may have forgotten to do when you added the code to your project.

Have your PPT that you want to add slides to open then click the "Create PPT Slides" button. Additional formatted slides will be added with the tables embedded so you can actually work on them.

HTH,
Maud

Your file with tables
Ell1.png

Fist table uploaded to silde
Ell2.png

PPT slides.xlsm

Hi Maud,

My superior actually wanted the slides to be in certain format. The presentation slides should be in this form: https://drive.google.com/open?id=0B4...VlOQ3Z1dmUtY1U

Is it possible to make the code to do this?
1. Detect the tables
2. Prompt the user which tables (put numbers) they want to include to which slides (another prompt and has to put slide number)
3. Using the presentation slide with this format (with the front page and the headers)
4. Make the table editable in presentation slides, instead of Excel

Your assistance is definitely appreciated. Thank you so much. Have a nice day.

Ell.

Hi Maud,

Thank you for your assistance. If the second request is not there, would this still time consuming as I have to submit this by next week? Another question is, let say I would like to paste it in range but it comes out as a table form in PPT, is it still editable?

Hi Ell,

Attached is a revised version that will copy ranges of data instead of tables. You can indicate which sets of data to include on a slide by placing markers between them in col A. The marker is a "|" (pipe symbol). I placed them in Cells A13, A24, A35, A48, etc.. Theses will combine your data set and related commentary data on the same slide. Since the ranges are embedded, like the tables in my previous modded code, they are editable (in edit mode not presentation mode).PPT slides_Rev1.xlsm

HTH,
Maud

Hi Maud, I tried your code the other day to new Excel file with only one table in one slide instead of 2 and I got this instead Capture.PNGCapture2.PNG

May I know why? From what I read in the code, it supposed to read every range until there's a marker where it then pastes the specific slide to specific table. And only one slide can be generated instead of 2.

Ell_,

First, let me make sure that your data is set up in tables, correct?

Only one table copied to one slide because you have only one pipe symbol ("|") after the first table. If you were to have added a second symbol after the second table then you would have ended up with two slides with one table on each.

It appears that the slide created has included the data from column A only (cells A1 to A6) since the "Notes / commentary" within the merged cells is actually in Cell A1. The reason why this happened is because the code looks at the first line and grabs the last column used. The number of the last column is used to define the range to copy.

In post #9, you can see a copy of your original sheet where the first line was a header using multiple columns. In your post above (post #12), your first line is now been changed to a merged notes / commentary where the last column across will evaluate to 1 so this is the reason why only one column was copied.

Delete row one so the header Plants / Efficiency / Reliability is the first row then rerun the code. You should now see the three columns copied to the slide.

HTH,
Maud

Originally Posted by Maudibe

Ell_,

First, let me make sure that your data is set up in tables, correct?

Only one table copied to one slide because you have only one pipe symbol ("|") after the first table. If you were to have added a second symbol after the second table then you would have ended up with two slides with one table on each.

It appears that the slide created has included the data from column A only (cells A1 to A6) since the "Notes / commentary" within the merged cells is actually in Cell A1. The reason why this happened is because the code looks at the first line and grabs the last column used. The number of the last column is used to define the range to copy.

In post #9, you can see a copy of your original sheet where the first line was a header using multiple columns. In your post above (post #12), your first line is now been changed to a merged notes / commentary where the last column across will evaluate to 1 so this is the reason why only one column was copied.

Delete row one so the header Plants / Efficiency / Reliability is the first row then rerun the code. You should now see the three columns copied to the slide.

HTH,
Maud

Alright thank you Maud.