Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2004
    Location
    Portsmouth, Hampshire, England
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Save Embedded Objects (2002 SP3)

    Don't know if this is the correct forum, but I'm sure you'll point me in the right direction...

    A colleague asked me if it was possible to programatically step through all the embedded PowerPoint objects in an Excel Worksheet and save them as separate PowerPoint files.

    I've got as far as:

    Set ppObj = Worksheets("Sheet1").OLEObjects(1)
    ppObj.Activate
    With ppObj.Object.

    but can't figure out how to get a handle on the actual object to instruct it to saveas and then close.

    Any pointers?

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Save Embedded Objects (2002 SP3)

    Reposted in Excel as <post#=436466>post 436466</post#>. Since there are replies there, I will lock this thread. Anyone wanting to react can do so in the other thread.

Posting Permissions

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