Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Melksham, Wiltshire, England
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clearing the clipboard (Excel 2000 vba/windows 2000)

    I'm changing a large number of workbooks (over 300) but after saving each book I have to manually empty the clipboard. How do I do this in code?
    Help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Clearing the clipboard (Excel 2000 vba/windows 2000)

    Application.CutCopyMode = False

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    Melksham, Wiltshire, England
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clearing the clipboard (Excel 2000 vba/windows 2000)

    Thanks Hans. I wouldn't have connected that with clearing the clipboard.

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clearing the clipboard (Excel 2000 vba/windows 2000)

    I have just experienced the same problem (see my posting) and have had the solution presented to me (one that works!)
    Place that following at the top of the module:
    Declare Function EmptyClipboard Lib "user32" () As Long
    All the other clipboard empty thingies did not clear the clipboard on my machine, but this one did.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •