+ Reply to Thread
Results 1 to 2 of 2

Excel to PPT - VBA no longer working with 2013

  1. #1
    Registered User
    Join Date
    04-15-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 365
    Posts
    49

    Excel to PPT - VBA no longer working with 2013

    Hi,
    Hoping someone could help, I have an excel workbook with several tabs/worksheets. and I found some VBA that converted a range on each worksheet into a shape a pasted it into a separate slide in a new work book.

    This however no longer works since we have moved to Office 2013.

    When the debugging screen comes up it highlights this row in step 7 - PPSlide.Shapes.Paste.Select

    Please Login or Register  to view this content.

    I hope someone can help.
    Thank you in advance.

    Brad
    Last edited by Jissenka; 05-15-2015 at 12:08 AM. Reason: Mark as Sloved

  2. #2
    Registered User
    Join Date
    04-15-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 365
    Posts
    49

    Re: Excel to PPT - VBA no longer working with 2013

    Hi,
    I may have found a solution myself.

    I removed the .select from the end of the problem line. (PPSlide.Shapes.Paste.Select)

    It is working so far

    If anyone else has a confirmation or can see any issues with this please let me know.

    Cheers,
    Brad


    EDIT: I have marked this as solved, thank you to all that viewed.
    Last edited by Jissenka; 05-14-2015 at 08:39 PM. Reason: Mark as Sloved

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Connection to authenticated website no longer works in Excel 2013
    By sasquashblue in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2014, 06:25 PM
  2. website hyperlinks no longer working in Excel
    By robert harris in forum Excel General
    Replies: 2
    Last Post: 06-11-2013, 04:33 PM
  3. Excel features mysteriously no longer working
    By GordonPSmith in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-18-2011, 03:58 PM
  4. Routine no longer working in Excel Module?
    By meridian2000 in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 06-17-2009, 09:20 AM
  5. [SOLVED] Help: Excel 4 macro suddenly no longer working
    By Keske Saram in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2005, 10:05 PM

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