+ Reply to Thread
Results 1 to 2 of 2

Edit chart size after copied from excel to PPTX file

  1. #1
    Registered User
    Join Date
    06-19-2019
    Location
    Viet Nam
    MS-Off Ver
    2016
    Posts
    27

    Edit chart size after copied from excel to PPTX file

    Hi everyone.

    Pls kindly support me.

    I want to resize the chart which copied from excel to PPT file.

    I have copied it from excel into the PPT successfully and now I want to edit size.

    The code as below. How to change this size chart ?

    Thanks in advance.

    Dim Sh
    Dim PP As PowerPoint.Application
    Dim PPpres As PowerPoint.Presentation
    Dim lngSlideNumbers(3) As Long
    Dim lngChartNumbers(3) As Long
    Dim lngIndex As Long
    Dim myslide As PowerPoint.Slide

    lngSlideNumbers(1) = 2
    lngSlideNumbers(2) = 10
    lngSlideNumbers(3) = 12

    lngChartNumbers(1) = 3
    lngChartNumbers(2) = 5
    lngChartNumbers(3) = 20

    'Create a PP application and make it visible
    Set PP = New PowerPoint.Application
    PP.Visible = msoCTrue
    'Open the presentation you wish to copy to
    Set PPpres = PP.Presentations.Open("C:\Users\Administrator\Desktop\Chart for PM\Line\2019.04.02-Vietnam market analysis (GFK).pptx")

    'For lngIndex = 1 To 3

    'Set the shape you want to copy
    Set Sh = Application.Worksheets("Make Chart").ChartObjects("Chart 18")
    'Copy the shape
    Sh.CopyPicture Appearance:=xlScreen, Format:=xlPicture

    'And paste it on the sixth slide
    PPpres.Slides(lngSlideNumbers(1)).Shapes.Paste

  2. #2
    Registered User
    Join Date
    06-19-2019
    Location
    Viet Nam
    MS-Off Ver
    2016
    Posts
    27

    Re: Edit chart size after copied from excel to PPTX file

    I have completed this Issue.

    Thanks you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract power point data (pptx) to excel in an orderly way
    By scottiex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2018, 12:26 AM
  2. Cannot resize properly embeded excel chart inside the pptx
    By vytenis12 in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 05-23-2018, 03:33 PM
  3. PPTX macro needed to change font size on an entire slide
    By kzaveri19 in forum PowerPoint Programing
    Replies: 1
    Last Post: 12-16-2016, 12:17 PM
  4. Size of Size of the Excel File saved on a networkdrive
    By cpmsimoes in forum Excel General
    Replies: 0
    Last Post: 08-12-2015, 06:01 AM
  5. Excel file size grows when copied
    By EsAssistant in forum Excel General
    Replies: 2
    Last Post: 12-10-2010, 05:53 AM
  6. Excel 2007 : File size has increased in size...Why
    By THORmx in forum Excel General
    Replies: 3
    Last Post: 02-12-2009, 02:39 AM
  7. excel chart file size
    By todicus in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-20-2005, 04:05 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