Results 1 to 3 of 3
  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419

    Excel Charts & Power Point Shapes Experts

    Hello,



    To Identify xlsx charts or pptx shapes we need to loop through them. Is there a way that
    after we ID the xlsx charts or powerpoint shapes we control it such as where to place them without
    having to loop through them to have control.

    Hope I am making sense.

    here is the code example of looping through them.

    Code:
    For each pt ins.shapes 
    
    Next pt 
    
    For Each o In w.ChartObjects 
             
    Next

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the code is not going to know the ID unless it runs thru the objects.

  3. #3
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    How about we already know the ID and use the ID to control them. Or in xlsx charts we copy them into say word, we don’t need to ID them because we already had position of the object by copy and then we place them in the position we want ?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Using Shapes from Excel within Access VBA
    By mcomp72 in forum Programming
    Replies: 2
    Last Post: 09-30-2017, 02:49 PM
  2. Power Point
    By Alex Motilal in forum Forms
    Replies: 2
    Last Post: 05-15-2017, 07:55 PM
  3. Replies: 1
    Last Post: 05-02-2017, 10:05 AM
  4. Replies: 1
    Last Post: 06-28-2016, 06:43 AM
  5. export to Power Point
    By lugnutmonkey in forum Import/Export Data
    Replies: 1
    Last Post: 02-23-2013, 11:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums