+ Reply to Thread
Results 1 to 8 of 8

Copying files from a folder without destination

  1. #1
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Copying files from a folder without destination

    I searched quite a bit, but can't find the answer to my problem. I want to copy all the files from a folder to memory or clipboard and paste it manually wherever I like to paste it.

    the codes that I have found, all have a destination folder. How can i achieve this?

    thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,890

    Re: Copying files from a folder without destination

    What about this? Add an Input box to ask where you want to paste the files.

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Re: Copying files from a folder without destination

    That wouldn't save my time as I have to browse folders on the other program(folders created randomly) and then paste it on the input box. I want to CTRL+V the files.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,890

    Re: Copying files from a folder without destination

    Sorry, but I don't have a better solution for you.

  5. #5
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Copying files from a folder without destination

    Maybe :
    Please Login or Register  to view this content.
    Sample usage :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

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

    Re: Copying files from a folder without destination

    Did you ever work with Excel ?



  7. #7
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Re: Copying files from a folder without destination

    can you explain how i could make this work on vba? where are there two codes?

  8. #8
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Re: Copying files from a folder without destination

    nothing major. I created a userform with the info that i found on here and google.

+ 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] Copying Files : Userdefined Location to user defined destination folder
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2016, 05:31 PM
  2. [SOLVED] Creating new folder, copying files and renaming files in folder
    By LionelNZ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2015, 04:18 PM
  3. [SOLVED] Copy certain files from Source folder to Destination folder
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2015, 08:56 PM
  4. Tracking what files are in a apecific destination folder
    By winwall in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-26-2014, 05:28 PM
  5. Replies: 1
    Last Post: 11-12-2013, 03:44 PM
  6. Replies: 0
    Last Post: 09-16-2013, 02:24 AM
  7. copying data from excel files in a source folder to target folder
    By Javed07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2013, 04:27 PM

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