copy cells to powerpoint slides

Hello,

I have a report that I run and format in excel, and then I paste the cells into a spreadsheet in power point over several slides. I'm trying to create a macro that will do this automatically, but I am having trouble getting Excel to communicate with Power Point. Right now I'm only trying to record the macro, because I don't know the code to get Excel to work with this other program, but that is not working at all. It registers what I want it to do in Excel fine, but when it comes to the Power Point side of the action, it just stops cold.

Anybody willing to help me out on this?

Thanks!

Bob,

Thanks for the quick reply. I'm about to head out for the weekend, but I wanted to touch base with you on this real quick. I put a check mark in the box next to Microsoft PowerPoint 12.0 Object Library. I think that is the right one.

I tried again with recording a macro to open the ppt file, but had no love from the macro. I'm going to go check out the help section for the next ten minutes before I get out of here, and I'll hopefully get back to this early next week. If I still run into problems, I will definitly head back here. Thanks for the tip!

Bob,

That makes perfect sense. Let me see if I can get it working. If I can't, I'll certainly take you up on that offer, and post them up here.

Bob,

Here are the two files I have. The power point is put up on a touch screen monitor, hence all the buttons.

At any rate, the first slide I am working with is number 15 (titled vendor board page 1)

Not realizing that there isn't a recorder in power point, it's making it harder for me to learn the code. What I need to have happen is for power point to open the excel table embedded in that page, and then paste the information in from the excel table (sheet 1). As it will only show so many cells, I then need it to move to slide 16, grab the next range of cells from excel, and paste it into that slide.

Does that all make sense?

If you could help me with this, at least get me started, I would greatly appreciate it.

And I just found out it's not letting me attach the power point file.

Bob,

Unfortunately one of the things they took out with powerpoint 2007 was the ability to record macros. There is a recorder if you type Alt+T, M, R, but whenever I try to use that, it throws up odd error messages constantly. Perhaps if you still have the recorder on your end, you'll be able to make something work.

Thanks for your help.

Bob,

Thanks for all the time you've put into helping me. I do appreciate it.