+ Reply to Thread
Results 1 to 2 of 2

vba copy Csv files from Source folder to Destination folder

  1. #1
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    vba copy Csv files from Source folder to Destination folder

    Appreciate help here, I have code which works somewhat but not what i need.
    Daily I have several Csv files d/loaded like ones below

    Wednesday, 26th February 2020 - Terang Races Neurals (1)
    Thursday, 27th February 2020 - Beaumont-Newcastle Races Neurals
    They always start with DayName and Day number

    I want the code to copy only todays date files to the destination
    I have code That I have been working on and it works but problem it copies eg: all thursdays *.* where as I need only Todays date files
    Here is the code
    Please Login or Register  to view this content.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: vba copy Csv files from Source folder to Destination folder

    Try this instead - using FileSystemObject rather than command line.

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

+ 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] File Copy From Target Folder To Source Folder
    By Kiran198028 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2019, 11:36 AM
  2. [SOLVED] Moving Files from Source Folder to Specific Folder
    By sammymalta in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-08-2018, 06:15 AM
  3. Different Hyperlinks as source folders to copy all files in new folder
    By mullean3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2017, 09:55 AM
  4. Replies: 18
    Last Post: 10-08-2017, 04:17 AM
  5. [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
  6. 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
  7. When i Copy Folder to new destination i lose customised folder icon/picture
    By sternboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-29-2012, 09:30 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