+ Reply to Thread
Results 1 to 10 of 10

Excel to PPT - editable form

  1. #1
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Excel to PPT - editable form

    Hi!

    May I know how to include in this code the selection to copy and paste in form of default?
    Here's the code that I have to edit:

    Please Login or Register  to view this content.
    I tried to edit the code by putting it in this way but it shows an error:

    Please Login or Register  to view this content.
    Btw, I'm still really new to VBA. Thanks for your help!

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Excel to PPT - editable form

    Hi
    have you tries replacing CopyPicture with Copy

  3. #3
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Re: Excel to PPT - editable form

    Hi Nicky,

    Yes I did. As shown in red, I tried to add new selection named "Data" in the case and whenever the user uses "Data" form, any cell ranges that they copy in that form are supposedly to follow PPPasteSpecial form as wrote in the next few lines, also in red. But then, it shows an error. May I know if I did any wrong anywhere?

  4. #4
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Excel to PPT - editable form

    Hi
    just looking at your code extract, it look like you have added in a new "If" condition without an "End If". Is that perhaps causing your error?

  5. #5
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Re: Excel to PPT - editable form

    Hi, Nicky

    I have added the "end if" but it shows syntax error. I believe my code is wrong in this line:

    Please Login or Register  to view this content.
    Any idea which part I did wrong?

  6. #6
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Re: Excel to PPT - editable form

    Hi, can anyone guide me in this matter? It has been weeks but I still could not find the reason why.

  7. #7
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Re: Excel to PPT - editable form

    Way to solve (quoted from a VBA Master in another forum):
    "When using Late Binding, convert Early Binding constants like ppPasteDefault to the constant number instead. ppPasteDefault=0"
    Please Login or Register  to view this content.
    You may also write in form of:
    Please Login or Register  to view this content.
    Both excerpt of code will ensure your data is exported to PPT and can be edited inside PPT.

  8. #8
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Excel to PPT - editable form

    Hi ell_
    sorry I did not reply earlier. I had another look at you code but couldn't spot an error. Have you now solved it?

  9. #9
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Re: Excel to PPT - editable form

    Hi NickyC,

    Yes. Thanks to an answer from another forum. I have updated the answer as per stated above. Thanks NickyC!

  10. #10
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Excel to PPT - editable form

    glad to hear that. Sorry I wasn't able to help

+ 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. Replies: 13
    Last Post: 10-12-2017, 08:46 PM
  2. Display the values in form that pull from another sheet which should not the editable
    By gopalkacat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2012, 03:48 PM
  3. Editable excel Uk maps!
    By JasonHopkins in forum Excel General
    Replies: 0
    Last Post: 01-17-2012, 10:02 AM
  4. Excel Query no longer Editable
    By elderkin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2011, 09:59 AM
  5. Add an Excel Worksheet to PowerPoint and have it editable
    By oddcarout in forum Excel General
    Replies: 1
    Last Post: 09-08-2010, 05:09 PM
  6. displaying a form while allowing sheet to be editable
    By justin111 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2009, 08:44 PM
  7. [SOLVED] Excel Editable Ranges
    By Andre in forum Excel General
    Replies: 0
    Last Post: 01-20-2006, 03:10 PM

Tags for this Thread

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