Creating Slides from Excel Data

**excelhelp18** · 08-26-2009, 01:57 AM

Hi,

Need your help on the following.

I have names of about 50 campaigns in col A in Excel.

I need to make a presentation on each campaign in PPT. Is there any way I can create these 50 slides having campaign name as header of each slide?

Thanks in advance.

**excelhelp18** · 08-26-2009, 03:41 AM

Hi,

Need your help on the following.

I have names of about 50 campaigns in col A in Excel.

I need to make a presentation on each campaign in PPT. Is there any way I can create these 50 slides having campaign name as header of each slide?

Thanks in advance.

**Andy Pope** · 08-26-2009, 04:11 AM

This should get you started in automating the creation of slides, based on data in column A.

Please Login or Register  to view this content.

Run this code from excel.

**Andy Pope** · 08-26-2009, 04:28 AM

Please don't post your question multiple times.

**excelhelp18** · 08-26-2009, 05:21 AM

Thanks for the support. It worked fine for me.

Just need a extention to my query..

1) I want to use an existing template to transpose the campaigns in Col A
2) I have data in col B as well. It will form a bullet point of Slide. How can I do that?
3) I want to pre-lock the text setting (Eg: Times new roman text, 14 size and underline) before transposing the campaigns details in slides. How can i do that.

Thanks in advance.

**satish.kumar** · 08-26-2009, 06:10 AM

how do i post a thread????

**Andy Pope** · 08-26-2009, 07:30 AM

satish.kumar please don't hijack other members posts.

Get the FAQs
http://www.excelforum.com/faq.php?fa...aq_vb3_posting

**Andy Pope** · 08-26-2009, 07:33 AM

1. Use open rather than add.

2. just use the same approach to populate other textboxes. You can use the .Offset(0,1) of the rngCell object to pick information from column B

3. you need to add slides based on your layout.

Try using the macro recorder in powerpoint, assuming you do not have ppt2007.

**excelhelp18** · 09-14-2009, 05:54 AM

Hi, Thanks for your inputs.

What I need is highlighted in the file attached. I need to have the budget and actuals info as shown in the pics attached in the excel.

I need to automatically create these slides with all the info in the excel attached.

Please help.

thanks in advance.