+ Reply to Thread
Results 1 to 3 of 3

value copied to clipboard now gives "[][]" (but still copies fine to dict->csv)

  1. #1
    Registered User
    Join Date
    12-08-2017
    Location
    Minneapolis, MN
    MS-Off Ver
    Standard 2013
    Posts
    83

    value copied to clipboard now gives "[][]" (but still copies fine to dict->csv)

    I have two subs for copying data from a cell where I want to copy only a selected substring, so it makes use of regex or other functions below. For this question, that fact can be ignored.

    They were working exquisitely before, and I dind't change naything, and now when I use the macro, it pastes [][] in my clipboard. I can see my clipboard history when I type win+v and it shows the [][] characters. You can look at the first sub below because it doesn't use regex so you know that's not the issue, and it was working before. That's the first I noticed started to fail. It's a much simpler setup. But when I do the second one below, but instead of copying to clipboard but sending the info to a dictionary and then to a csv, it works fine, so I know it extracts the right values.

    Why does clipboard start showing and pasting [][] instead of the number I intend to copy? Has anybody ever encountered this?


    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: value copied to clipboard now gives "[][]" (but still copies fine to dict->csv)

    There's a bug with the DataObject that can cause that in Win8 or later if you have Explorer windows open. Using API calls is safer.
    Rory

  3. #3
    Registered User
    Join Date
    12-08-2017
    Location
    Minneapolis, MN
    MS-Off Ver
    Standard 2013
    Posts
    83

    Re: value copied to clipboard now gives "[][]" (but still copies fine to dict->csv)

    ok thanks. I figured it out as well. For those reading, this link might help.
    https://chandoo.org/forum/threads/cl...dows-10.37126/

    For now I closed the windows explorer. Later I may practice with API calls

+ 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: 0
    Last Post: 02-27-2019, 02:32 PM
  2. [SOLVED] Date in Excel ("30/09/2016") copies incorrectly into Access ("30/05/1905")
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-30-2017, 05:19 AM
  3. [SOLVED] "Store Value in DICT and Change Color if not exist"
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2017, 06:56 AM
  4. [SOLVED] Code that copies row of data to another sheet based on text "Complete"/"Delete"
    By Dremzy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-20-2014, 05:51 PM
  5. Replies: 2
    Last Post: 04-20-2014, 11:18 AM
  6. [SOLVED] Program was working fine, now im getting an error with "entire column.autofit"
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2013, 02:16 PM
  7. [SOLVED] Store clipboard before "vba do cut&paste" then recover stored information to clipboard?
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2006, 02:00 AM

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