Hi

I have read with interest the many posts and suggested web sites relating to
the code for pasting from excel into powerpoint. However I still have a
couple of issues and would be grateful of some assistance.

1) Despite following the posted advice I cannot launch powerpoint from excel.


2) On sheet 1 I have a table with the following comlumn headers


Ref No. Type Project Name Actual End Date
272 QS LNE number
333 QS BLAH BLAH 13/Feb/2008

Each row relates to a specific sheet with the type and ref no. being the
sheet name ie QS 272.
I would like to be able to loop through the table on sheet 1 and for each
row where there either isn't an actual end date, or the actual end date is <=
today() - 7 (ie no more than a week old) and copy the relevant range from the
related sheet into a new slide in powerpoint.


Thanks for all assistance with this.

Richard

I have read with interest the many posts and suggested web sites relating
to
the code for pasting from excel into powerpoint. However I still have a
couple of issues and would be grateful of some assistance.

1) Despite following the posted advice I cannot launch powerpoint from
excel.

What did you try, what errors did you encounter?

Have you seen this page:
http://peltiertech.com/Excel/XL_PPT.html


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______