Excel VBA Copy/Paste Opens SkyDrive Folder RRS feed

  • Question

  • Background

    Last summer, I got a new PC with Office 2010 already installed. Throughout the years, I have done a lot of VBA programming but I have never seen this issue. On to the problem.

    I have created several VBA programs which analyze other spreadsheets and when I detect a row in the spreadsheet that I want to save, I copy that line in the scanned spreadsheet into a new spreadsheet. All of the macros are different but all seem to have the same issue. 

    During some of the row copy and pastes, a windows explorer window automatically opens to my windows SkyDrive folder (I have the desktop version of SkyDrive installed). It is a completely random event and even if I run the application again, it doesn't occur at the same location. I have attempted to re-write the copy paste command in several different forms but nothing has prevented this from happening. I believe it is a bug somewhere in Excel VBA and/or SkyDrive (no other folder opens automatically). BTW, there are no references to the SkyDrive folder in anything I am coping.

    Anyway, just curious if anyone else has experienced this very strange behavior. Thanks
    • Edited by PTMark Thursday, January 31, 2013 8:33 PM
    Wednesday, January 30, 2013 6:17 PM

All replies

  • Open explorer window/right click -> properties/Shortcut -> Shortcut kay.

    If you have something else then "NONE" - that's can be a solution.

    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Friday, February 1, 2013 9:54 PM