+ Reply to Thread
Results 1 to 3 of 3

VB Code to PasteSecial Html

  1. #1
    Registered User
    Join Date
    09-24-2007
    Posts
    60

    VB Code to PasteSecial Html

    What is the syntax to paste special HTML.
    The following is giving me errors.
    Please Login or Register  to view this content.
    Error is ""Shapes (unknown member) : Invalid request. Clipboard is empty or contains data which may not be pasted here"

    When I run this to the above error and go to PPT and paste it is the range that I want.

    Well I replaced it with PasteEnhancedMetafile and it worked fine, but I need it as HTML
    Last edited by elfvis; 03-20-2012 at 12:24 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: VB Code to PasteSecial Html

    Just turn on the macro recorder and do this manually once. Stop the recorder and exam/modify the code.

  3. #3
    Registered User
    Join Date
    09-24-2007
    Posts
    60

    Re: VB Code to PasteSecial Html

    The macro recorder does not record when moving to ppt.

    Thanks for the idea.

+ 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