Import Multiple Excel Spreadsheets to PowerPoint Individual Slides

[CCHall]

Does anyone have some VBA code that would import individual worksheets from an Excel file into individual slides of a PowerPoint presentation? I want them to still be Excel tables, not pictures. If I just import from Excel, it only takes the first worksheet. If I do a paste special, I have to paste it as a picture.

Thanks for any help!

--CC Hall

 

[CCHall]

I forgot to mention that I am using MS Office 2003. Thanks.

-CC Hall

 

[SkipVought]

Hi,


Copy each sheet range and paste into PP.

Skip,

_[red][/red]

 

[CCHall]

Thanks for your reply. PowerPoint will only let me copy and paste as a picture, which I don't want.

--CC Hall

 

[SkipVought]

???

Edit/Paste Special - Microsoft Office Worksheet Object

Skip,

_[red][/red]

 

[CCHall]

Thanks, when I'd tried that before, the text was all black instead of the colors I'd chosen. This time, I double clicked the object once it was pasted, then clicked outside it again, and the text colors were correct. Weird! Thanks for your help.

--CC Hall