+ Reply to Thread
Results 1 to 9 of 9

Excel to Powerpoint export

  1. #1
    Registered User
    Join Date
    04-01-2009
    Location
    new delhi
    MS-Off Ver
    Excel 2003
    Posts
    45

    Excel to Powerpoint export

    I am trying to re use the following code to transfer all my excel 2007 charts to a powerpoint presentation. The problem with the existing code was it could not transfer charts that are moved as sheet itself.
    For that I have introduced a new loop to capture those charts (marked in red). I am assuming that I am not using right object.
    Please Login or Register  to view this content.
    I apolosize for my last post, in which I didn't wrapped my code in tags


    Please advice.

    Thanks,
    Webbug


    Full code
    Please Login or Register  to view this content.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,423

    Re: Excel to Powerpoint export

    I have not had time to work up an example. If you posted a sample xls, it would help us help you. Until then, this thread might be of some help. http://www.excelforum.com/excel-prog...nt-slides.html

  3. #3
    Registered User
    Join Date
    04-01-2009
    Location
    new delhi
    MS-Off Ver
    Excel 2003
    Posts
    45

    Re: Excel to Powerpoint export

    Dear Sir,

    Thank you for helping me.
    I have attached an excel with some Q&D charts.

    Thanks,
    Webbug
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,731

    Re: Excel to Powerpoint export

    Try,

    Please Login or Register  to view this content.
    Note that in xl2007 the xlBitmap argument makes no difference due to a bug.
    It will be treated as xlPicture
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    04-01-2009
    Location
    new delhi
    MS-Off Ver
    Excel 2003
    Posts
    45

    Re: Excel to Powerpoint export

    Thank you.

    Its is working now...

    webbug

  6. #6
    Registered User
    Join Date
    04-01-2009
    Location
    new delhi
    MS-Off Ver
    Excel 2003
    Posts
    45

    Re: Excel to Powerpoint export

    I will really appreciate if you could also suggest appropriate modification as to

    if there are any active presentation available, code add charts on that, if not it will create a new one. I have tried using the following code for activating any existing ppt.

    Please Login or Register  to view this content.



    Please Login or Register  to view this content.
    Thanks for your great helps.

    Webbug

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,731

    Re: Excel to Powerpoint export

    Use activepresentation.
    Please Login or Register  to view this content.
    You may find the count is always greater than zero as a blank presentation is opened when the application starts.

  8. #8
    Registered User
    Join Date
    04-01-2009
    Location
    new delhi
    MS-Off Ver
    Excel 2003
    Posts
    45

    Re: Excel to Powerpoint export

    Many Thanks..

    Webbug..

  9. #9
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,423

    Re: Excel to Powerpoint export

    Here is a GetObject method to add to an existing Presentation or add to a new one if not.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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