• Save Embedded Objects (2002 SP3)

    Author
    Topic
    #413574

    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

    Viewing 1 reply thread
    Author
    Replies
    • #913530

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

    • #913531

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

    Viewing 1 reply thread
    Reply To: Save Embedded Objects (2002 SP3)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: