Creating PowerPoint Slides from Excel

[BillDickenson]

I have a standard workbook that we use for estimating. When the project completes, we take some of the worksheets, cut/paste them into powerpoint, add other slides and send out for review.

I would like to write a macro to automagically copy selected sheets/areas/ranges from Excel into a new Powerpoint file, multiple pages. Oddly enough, I can't seem to find any decent samples. Anyone got one ? Thanks

 

[mike1955]

try running macrorecord in excel as you do it manually. It records all inter-office transactions. It will give you a pointer as how to manage automation. If macrorecord is on before you open pp you will also get the new pp code.