Dear Tom, Many thanks for reply.
Just one query.... we have special slide format. i.e. back ground. once if i define that in my PPT can it be possibel to change just value of the slide? reason for this is we have standared format. that's maroon background and white font and size is say 14 & 12. Look forward to hear from you soon. Regards, Viral Pandya On 1/6/09, Tom Jeffries <tjeff...@gmail.com> wrote: > > This may help > > To create a link from PowerPoint to the info in your Excel file. > > 1. If you're working with content on a worksheet rather than on a > chartsheet and don't want grid lines in your PowerPoint presentation, choose > Tools, Options, View and remove the checkmark next to Gridlines; then click > OK. > > 2. Save the Excel file that contains your information if you haven't > already done so. > > 3. In Excel, select the information you want to use, then press > Ctrl+C or choose Edit, Copy. > > 4. Switch to PowerPoint and move to the slide where you want to use > the information from Excel. You should be in Normal or Slide view. > > 5. From the Edit menu, choose Paste Special. > > 6. In the Paste Special dialog box that appears, click the "Paste > Link" option button, then click OK. > > This creates a link to the information in your Excel file. Each time you > open the presentation, PowerPoint offers to update the links. If the linked > information in the Excel file has changed, this updates it in your > PowerPoint presentation also. > > You can double-click the linked information to launch Excel with your > linked file open for editing. When you save the edited file and return to > PowerPoint, once again, the updated information appears in your > presentation. > > In order to update linked information and launch the linked file for > editing, PowerPoint must be able to locate the file, so be sure to keep the > linked file and your PowerPoint file in the same locations on your hard > drive, or make sure that the linked Excel file stays in the same folder as > the PowerPoint file. > > If the linked file isn't present, you'll still be able to view and print > the information, but you won't be able to update or edit it. > > On Tue, Jan 6, 2009 at 4:23 AM, VIRAL PANDYA <pandya....@gmail.com> wrote: > >> Dear All, >> >> I am Viral. Working in as MIS Executive. >> >> Every month I need to creat a detailed presentation for our monthly >> perfromance meeting. >> >> Can you help me with code that convert my date from Excel to current open >> powerpoint file in defined slide? >> >> Briefing you more abt what i want is... >> >> we have 24 slides in our MPR presentation. >> >> I workout date in excel and copy the same and paste in Power point as >> EXCEL OBJECT. >> >> now i and sheet 1 (say Sales Varience to paste on slide no 2). >> >> Sheet 2 (say receivables date to paste on slide no 3). >> >> Look forward to hear from you soo. >> >> Regards, >> Viral Pandya >> +91-992-432-1990 >> >> >> >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
