+ Reply to Thread
Results 1 to 9 of 9

Re-Write Code Without Clipboard

  1. #1
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Re-Write Code Without Clipboard

    Can someone help me re-write this code without using the clipboard? I have the following macro that copies and pastes data every 10 seconds all day long and as a result I cannot cleanly use the copy and paste function on my computer for any other programs.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Re-Write Code Without Clipboard

    The secret is to not copy to the clipboard (you knew this)
    So instead of the form:
    Please Login or Register  to view this content.
    you use the commands
    Please Login or Register  to view this content.
    No clipboard used...

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Re-Write Code Without Clipboard

    You already got this in your other thread:

    Please Login or Register  to view this content.
    Last edited by teylyn; 09-27-2010 at 06:16 PM. Reason: restored original post



  4. #4
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Re: Re-Write Code Without Clipboard

    Marvin P - I am not sure how to apply that format to my code. The code gets complicated in some parts

    SNB - I tried adding your code and nothing copies at all.

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Re-Write Code Without Clipboard

    the macroname had to be changed.

    Please Login or Register  to view this content.
    Last edited by shg; 09-27-2010 at 05:34 PM.

  6. #6
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Re: Re-Write Code Without Clipboard

    SNB- I changed the code and still nothing copies. I do not recieve any errors either.



    Please Login or Register  to view this content.

  7. #7
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Re-Write Code Without Clipboard

    snb, as a general rule, do not change the contents of a post after it has been replied to. It breaks the logical flow of the thread.

    If you have any adjustments to make or errors to correct, please do so in a new post. I've restored the original version of post #3.

  8. #8
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Re-Write Code Without Clipboard

    You shouldn't add my code but use it instead of yours.
    And please, read it again carefully.

  9. #9
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Re: Re-Write Code Without Clipboard

    Okay, I added your code and nothing copies at all

+ 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