View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Excel Data to Powerpoint

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