Results 1 to 1 of 1

Separate image too large in two slides powerpoint

Threaded View

  1. #1
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    25

    Separate image too large in two slides powerpoint

    Hi i have a xls source file, where the macro takes all data, these data are organized in charts, one chart every spreadsheet.
    I set up the macro to export these charts in a powerpoint file.

    I must create a ppt presentation, but when i paste the chart on the slide the problem is the lenght…i would set a cycle to do:
    when the cycle finds a particular value (such as in the example CAR-1010), it should stop paste, add a new slide.
    On the new slide paste chart's first row (target, etc.....) and the last part of the chart, from Car- 1010 to the end
    if is it pobbile i would align what has pasted by the bottom.

    i set up the following text

    
    
        ThisWorkbook.Worksheets("Sheets1").Activate
        xlapp.Range("e1:h22").Select
        xlapp.Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
        pptApp.ActiveWindow.View.GotoSlide (4)
        Set ppslide = pptApp.ActiveWindow.View.Slide
          
          
        pptApp.ActiveWindow.Selection.ShapeRange.Align msoAlignCenter, True
        pptApp.ActiveWindow.Selection.ShapeRange.Align msoAlignMiddles, True
    I added a xls to show what i meant....
    Thank you!!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MACRO to create Powerpoint slides PDF
    By blackhawk4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2013, 12:42 PM
  2. Make a powerpoint slide that scrolls down a large image.
    By 111StepsAhead in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 03-18-2013, 03:16 AM
  3. copy cells to powerpoint slides
    By just_some_guy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-08-2010, 09:34 AM
  4. VBA to update PowerPoint slides.
    By bapatterson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2010, 01:44 PM
  5. Excel formulas on different Powerpoint Slides
    By liseladele in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-31-2006, 07:28 PM

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