+ Reply to Thread
Results 1 to 2 of 2

Need Help to Prepare PPT from Excel Raw File through VBA???

  1. #1
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    Smile Need Help to Prepare PPT from Excel Raw File through VBA???

    Dear Friends,

    Good Day to you!!! I need your help to accomplish below critical task… Please do suggest me possible way ASAP.

    Every month beginning I have to summit & Present the Month Revenue performance for my Account and for which I have to prepare the PowerPoint by referring too many Raw Data from Excel File.
    Now, I have consolidated all the raw data into one Work book i.e. single Excel file, (For Example: Please find the attached file).

    My main intention here is, once I update all the relevant data in the Raw file for month, Just I want to click a Macro button & I need a well structured professional PPT to be generated by using the Raw File.
    While Macro transfers the data from Excel to PPT it has to take care all below Criteria:-
    In the attached Excel File:-

    1. First sheet is named as “Agenda” and last sheet is named as “Thank You”. So I want the macros to keep transfer the data from 1st sheet to last sheet of the Excel File. (The reason behind this is, In Future I may include some more sheets in between this…!)

    2. Respective “Excel work sheet name” has to assign as Heading (Font Style : Arial & Font Size : 40) of the Each Slide and what is the print area is been set in that particular work sheet has to copy paste special as “Bitmap” in body of slide.

    3. While Copy pasting the data, It has to paste as best fit to the Slide. So that I do not need to align further before presenting.

    4. One more important thing is, we have our own PPT Template for the presentation. So , please design the VBA in such a way that, it will transfer the data to particular PPT only which is defined as below

    \\Company Name\Division\Department\ProjectReviewPresentation.PPT

    Thanks & Regards,
    Rajeshkumar R
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Need Help to Prepare PPT from Excel Raw File through VBA???

    Hi
    try this macro
    in the visual basic area, ensure ensure tools > references > powerpoint object library is selected so you can run PowerPoint code from excel


    Please Login or Register  to view this content.
    Last edited by NickyC; 10-29-2012 at 10:28 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1