LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Excel spreadsheet with Powerpoint Data Wi11y13 Excel Discussion (Misc queries) 1 September 14th 09 09:29 PM
can I merge data from Excel document into PowerPoint presentation judith28 Excel Discussion (Misc queries) 1 November 9th 08 11:03 PM
Excel spreadsheets with data, Powerpoint charts... and VBA! Petitboeuf Excel Discussion (Misc queries) 1 May 26th 06 11:15 AM
copying data from Powerpoint to Excel DB Excel Programming 2 August 9th 05 04:34 PM
pasting excel data in a powerpoint slide James Excel Discussion (Misc queries) 4 January 28th 05 02:23 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"