+ Reply to Thread
Results 1 to 3 of 3

Copy a folder in clipboard

  1. #1
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Copy a folder in clipboard

    Hello,
    Is it possible to copy a folder in clipboard using a VBA script?
    For example, I need this folder:
    C:\MyDocs\FolderToCopy to put in clipboard so later I can paste it.
    Could you please advise?
    Thanks

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Copy a folder in clipboard

    Here ya go. I copied it from the internet myself. You run it from Module1.
    https://stackoverflow.com/questions/...-but-not-paste

    Seriously, I think I converted it to 64 bit myself by replacing Long with LongPtr on all places but one: https://docs.microsoft.com/en-us/off...gptr-data-type

    Here is another link that I don't understand much of but I think it's pretty cool: https://wellsr.com/vba/2015/tutorial...d-paste-clear/
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Re: Copy a folder in clipboard

    Thank you Jacc!

+ 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. [SOLVED] Copy Range from multiple Workbooks in folder, to Summary Workbook also in same folder?
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-24-2018, 01:22 PM
  2. Copy From Clipboard to Find Value on Pivot Table, Copy to Different Cell
    By msdcanto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2018, 01:21 PM
  3. Replies: 12
    Last Post: 03-09-2015, 05:52 PM
  4. Copy all emails in outlook folder and paste them in similar system folder and ms access
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2014, 07:31 AM
  5. search for a file in a folder based on data, copy and paste it in another folder
    By kboy1289 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 11:47 AM
  6. [SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 07:59 PM
  7. Copy one cell to an other but colors do not copy. While not using clipboard to copy.
    By chuckchuckit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2010, 03:08 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