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
|