+ Reply to Thread
Results 1 to 2 of 2

Trouble using a macro in excel that involves Powerpoint

  1. #1
    Registered User
    Join Date
    03-19-2011
    Location
    Milan, Italy
    MS-Off Ver
    Excel 2003
    Posts
    1

    Trouble using a macro in excel that involves Powerpoint

    I use Windows XP Professional, Service Pack 3, Office 2003.

    I must copy&paste thousands of times some charts from excel to ppt and i wanted to use a macro using VBA.

    I found in internet some scripts that creates slides and objects in powerpoint from excel, so i tried to use them to understend how to handle powerpoint objects from a script in excel.

    I've found this kind of script:

    Please Login or Register  to view this content.
    Before using this macro, I checked the Tools --> References --> Microsoft Powerpoint 11.0 Object Library.

    Anyway, when I try to use this script, I get a run time error. It says that the library is not registered.

    In my Italian version of office is:
    "Errore di run-time '-2147319779 (8002801d)':
    Errore di automazione
    Libreria non registrata."

    The line of code where it appears is:
    Please Login or Register  to view this content.
    I think VBA cannot use the PPT OLB library, but I don't know why. MSPPT.OLB is in my Microsoft Office/Office11 directory.

    Thank you very much

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

    Re: Trouble using a macro in excel that involves Powerpoint

    Have a read of this
    http://peltiertech.com/Excel/XL_PPT.html

    You will see you need to createobject to get a reference to the powerpoint application.
    Cheers
    Andy
    www.andypope.info

+ 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